Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I'm trying to use the relative date filtering in PowerBI Desktop (RS October 2017) for one of the reports. I noticed that relative date filtering is based on time in UTC and picks up current date according to that. Is there any way that I can change this behavior ?
Thanks.
Solved! Go to Solution.
Hi,
Based on my research, currently the relative date filter is limited as “Based on the time in UTC”, referenced the official document, from “Limitations and considerations” session,
“The slicer and filter are always based on the time in UTC, so if you configure a filter in a report and send it to a colleague in a different time zone, you'll both see the same data. However, if you aren't in the UTC time zone you might see data for a different time offset than you expect.”
See Use a relative date slicer and filter in Power BI Desktop
So I am afraid currently it is not possible to change the routine. You could post an idea to https://ideas.powerbi.com/forums/265200-power-bi-ideas.
Best Regards,
Henry
Hi,
Based on my research, currently the relative date filter is limited as “Based on the time in UTC”, referenced the official document, from “Limitations and considerations” session,
“The slicer and filter are always based on the time in UTC, so if you configure a filter in a report and send it to a colleague in a different time zone, you'll both see the same data. However, if you aren't in the UTC time zone you might see data for a different time offset than you expect.”
See Use a relative date slicer and filter in Power BI Desktop
So I am afraid currently it is not possible to change the routine. You could post an idea to https://ideas.powerbi.com/forums/265200-power-bi-ideas.
Best Regards,
Henry
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |