Forum Discussion

Anushka's avatar
Anushka
New Member
8 years ago
Solved

relative date filtering

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 curr...
  • v-jianhe-msft's avatar
    v-jianhe-msft
    8 years ago

    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

v-jianhe-msft's avatar
v-jianhe-msft
Resolver II
8 years ago

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