Forum Discussion
Advocate ITime 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 am and 2 pm but it is showing 3pm and 7 pm ( which is in future)
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.
6 Replies
- tayloramy
Super User
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.
ForgotIDThanks a lot tayloramy. Is there any way I can convert the UTC in local time zone
v-aatheequeCommunity Support
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.
