Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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.
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.