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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Learner_SG
Helper IV
Helper IV

Power BI Time filter from UTC to local time

Hi , this question has been asked several times in power bi community but I could not find a concrete and esaier way to solve it.

So, asking one more time,incase someone has a better solution.

 

I need to display  the dashboard data of the last 1hr time. BUt when I insert the time filter, it displays the UTC time . I need to display in my local time. Is it possible? Could help?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Learner_SG ,

 

The slicer and filter 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 or your colleague are in the same UTC time zone, you both must account for the time offset you’ll experience. Use the Query Editor to convert data captured in a local time zone to UTC.

Screenshot 2022-03-16 171533.png

 

Use a relative time slicer or filter in Power BI - Power BI | Microsoft Docs

 

Best Regards,

Stephen Tao

 

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

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @Learner_SG ,


Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.


Best Regards,
Stephen Tao

Anonymous
Not applicable

Hi @Learner_SG ,

 

The slicer and filter 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 or your colleague are in the same UTC time zone, you both must account for the time offset you’ll experience. Use the Query Editor to convert data captured in a local time zone to UTC.

Screenshot 2022-03-16 171533.png

 

Use a relative time slicer or filter in Power BI - Power BI | Microsoft Docs

 

Best Regards,

Stephen Tao

 

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

amitchandak
Super User
Super User

@Learner_SG , Usually Now() in dax should give local time

 

and DateTime.LocalNow() in power query should give local time

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi @amitchandak , but when I bring it into the power bi filter to get the relative time, it automatically goes to the UTC time.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.