Relative Time Slicer in UTC instead of Local

[PBInewuser]

The time is reflected in UTC rather than PST.

Please advise.

[marcopol]

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

[anithaRavi]

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!

[marcopol]

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

[v-alq-msft]

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]

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.

[PBInewuser]

Thanks for the response.

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