Skip to content
This repository has been archived by the owner on Apr 26, 2024. It is now read-only.

Prevent times from being changed to UTC #1016

Open
markseeto opened this issue Jun 27, 2022 · 3 comments
Open

Prevent times from being changed to UTC #1016

markseeto opened this issue Jun 27, 2022 · 3 comments

Comments

@markseeto
Copy link

I'm using date/time variables on a data axis.

My time zone is UTC+10:00, and Charticulator subtracts 10 hours from the date/time values, which I don't want. Adding 10 hours to the times is not an adequate solution because my report is going to be used by people in different time zones, so I think the required adjustment will depend on the user's time zone.

I've tried doing an adjustment in Power Query using the time zone from DateTimeZone.LocalNow(), but this isn't ideal because I think it requires the data to be reloaded.

Is there a way I can prevent Charticulator from changing the times to UTC? I've tried making my date/time values appear to be UTC by adding the "+00:00" time zone, but that didn't work.

Thanks.

@zBritva
Copy link
Contributor

zBritva commented Sep 6, 2022

@markseeto Could you give context: do you use Charticulator visual or Charticulator in web page?

@markseeto
Copy link
Author

@zBritva Thanks for your reply.

I'm using a Charticulator visual in a Power BI report. The visual uses a template that I made on the Charticulator website.

My dates/times have no time zone specified. I'm hoping they can just be displayed without any adjustment or conversion being applied.

Thank you.

@yamapenny
Copy link

I also face the same issue when using charticulator visual in PBI. Any update for this? Looking forward to the solution/workaround.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants