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.
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.
Did I answer your question? Mark my post as a solution!