Time Relative filter

[ForgotID]

I am trying to use Time Relative ( in the last hour) filter but when I select last 4 hours it returns the Future time instead of last hour.

It is 2 pm now and the filter time should be between 10:00 am and 2 pm but it is showing  3pm and 7 pm ( which is in future)

[ForgotID]

Thanks a lot tayloramy. Is there any way I can convert the UTC in local time zone

[v-aatheeque · Accepted solution]

Hi @ForgotID 

You can convert UTC to your local time zone in Power BI using Power Query.

Reference : https://cloudbi.com.au/converting-utc-to-local-datetime-in-power-bi/

Hope this helps !!
Thank You.

[v-aatheeque]

Hi @ForgotID 

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.

[v-aatheeque]

Hi @ForgotID 

Just checking in to see if you had a chance to review the previous response. If you still need assistance, please let us know and we’ll be glad to help.

[v-aatheeque]

Hi @ForgotID 


We’d like to check if you were able to go through the previous response to your issue. Please let us know if you need further clarification we’ll do our best to support you.

[tayloramy]

Hi @ForgotID ,

The “Relative time” slicer/filter in the Power BI Service runs in UTC, not your local time. So when you choose “last 4 hours” at 2:00 PM local, the filter window is anchored to UTC, which can make your axis labels look like they’re in the “future” (e.g., 3–7 PM) if your data/visuals are showing local time. This is expected behavior per Microsoft’s docs (Relative time slicer/filter).

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.