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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PBInewuser
Microsoft Employee
Microsoft 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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors