Forum Discussion
Microsoft EmployeeDynamic Timezones in PowerBI Service
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.
Hi v-tomars
All the Power BI Servers are in UTC as per my blog post below
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.
1 Reply
- GilbertQ
Super User
Hi v-tomars
All the Power BI Servers are in UTC as per my blog post below
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.