Add changing time zone in slicer

[NikNithiy]

Hi All,

I would like to add a slicer with options to change the time zone(CT,EST,IST etc) because our requirement is the end user in power bi service need to change the time zone and obtain report. the Dynamic M query with not help us as we connect to live connection mode. Even i tried creating the paramaters in power query and created a column which dynamically changes the date/time zone based on paramter values but unfortunely i was not able to find a solution to add this paramater as a slicer for end user.

Can anyone aware of this or know a way to create a slicer where end user  able to switch between different time zone. So far our report comprise of EST time zone

[Ritaf1983 · Accepted solution]

Hi @NikNithiy 

This article should help :
https://www.inkeysolutions.com/blogs/power-bi-how-to-handle-multiple-time-zones/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly