Date time zone conversion

[Anonymous]

Hi,

I have date time value in UTC or converted to UTC. I want to display these time as per the user accessing the report. E.g. if I am accessing in MST all time should be adjusted to MST. Report is accessible across globe.

I used datetimezone.tolocal but it is publishing in IST only as my desktop is in IST and every sees IST only even if they are in MST. Any solution to this?

[Sumanth_23 · Accepted solution]

hi @Anonymous - It is good that you have the date available in UTC.

There is no way to dientify and display the data dynamically in different timezone.

You can use the approach described in the below link to setup the report so User can select which timezone they want to view the report in:

https://whitepages.unlimitedviz.com/2020/10/dynamic-time-zone-conversion-using-power-bi/#:~:text=This%20is%20because%20the%20Power,date%2Ftime%20values%20are%20paramount.

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

Sumanth

[Anonymous]

We found a table in db which has timezone w.r.t to user and offset from UTC. It's done!