Dynamic Timezones in PowerBI Service

[v-tomars]

Hi,

I have a datetime column having data in pst timezone, i want to display the data using the relative date slicer and have users in ist and pst timezones. Is there any way to implement dynamic timezone which would convert the datetime column to end user's timezone?

I tried using DateTimeZone.ToLocal in PowerQuery but it didn't work.

Appreciate any help on this, thanks in advance.

[GilbertQ · Accepted solution]

Hi @v-tomars 

All the Power BI Servers are in UTC as per my blog post below

Power BI – Did you know ALL Power BI Services Servers are in UTC? Now how to handle it for Dates & T...

The only way I could think of getting this to work is to create a new column in Power Query for IST and PST timezones. I would then have a way to switch between the different timezones which the user can then use to show it in their relevant timezone.