Forum Discussion
Relative Time Slicer UTC
Hi JayBI ,
For the latest version of powerbi desktop, slicers and filters are always based on the time in UTC, and they cannot be deleted or blocked. My suggestion is that you can use now() to get your time zone, and then create a card visual to illustrate the time zone difference to remind your customers.Regarding your question, I think it is a good idea. I will promptly report back to Microsoft official, hoping to implement this feature in the next update.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-henryk-mstf ,
Thank you so much for your detailed reply.
I've implemented your suggested steps and the data is filtered as intended by the slicer.
The main gripe I have with the slicer is that indication of the datetime range is still in UTC as shown in the black box below in the image of the relative time slicer. Following that is an image of the equivalent time in my timezone.
The display of the datetime range in the slicer is in UTC and not in my timezone, which may confuse local users of the dashboard. So I was wondering if the datetime range in the black box can be displayed in my timezone, or removed entirely to prevent any confusion to users?
Thank you so much for your help!
Best Regards,
Jay
Hi JayBI ,
For the latest version of powerbi desktop, slicers and filters are always based on the time in UTC, and they cannot be deleted or blocked. My suggestion is that you can use now() to get your time zone, and then create a card visual to illustrate the time zone difference to remind your customers.
Regarding your question, I think it is a good idea. I will promptly report back to Microsoft official, hoping to implement this feature in the next update.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.