Power BI Time filter from UTC to local time

[Learner_SG]

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?

[Anonymous]

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 · Accepted solution]

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.

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]

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

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

[Learner_SG]

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