Forum Discussion
Solved
Time Relative filter
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...
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.
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.