Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
PBInewuser
Employee
Employee

Relative Time Slicer in UTC instead of Local

The time is reflected in UTC rather than PST.

Please advise.

Capture.PNG

 
 
6 REPLIES 6
marcopol
Advocate I
Advocate I

2022 and Microsoft doesn't have an easy solution for this. It's frustating.

anithaRavi
Frequent Visitor

Looks like this issue does not have the correct solution yet. I tried all the above advices and it did not work for me. The issue is how to get the local time in the Slicer visualization for Relative Time. Currently the highlighted is the UTC DateTime. Please suggest options that work. Thank you!

anithaRavi_0-1606336949163.png

 

I don't think there is a solution. I've been looking for it as well, it's ridiculous

v-alq-msft
Community Support
Community Support

Hi, @PBInewuser 

 

As is mentioned in the document , the relative slicers and filters are always based on the time in UTC. If you set up a filter in a report and send it to a colleague in a different time zone, you both see the same data. Unless you are in the UTC time zone, you and your colleague must account for the time offset you experience. You may try to set the locale in Power BI Desktop as  Supported languages and countries/regions for Power BI.

 

Additionally, you can modify the datetime by DAX or Power Query.

DAX:

 

PST Datetime = Table[UTC Datetime]-7/24

 

Power Query:

 

=DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),-7,0)

 

 

For further information, you may refer the following links.

Solving DAX Time Zone Issue in Power BI

Daylight Saving Time And Time Zones In M

 

Best Regards

Allan

 

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

 

kentyler
Solution Sage
Solution Sage

You probably have a date table. If you add a "time" table you can have a column that lists the PST time that corresponds to every UTC time. If you relate that to your fact table on the UTC time, then the PST time will be available for you to use.





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Thanks for the response.

I have added time table, however the slicer still reflects in UTC.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.