Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date time zone conversion

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 ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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