cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anushka Frequent Visitor
Frequent Visitor

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 current date according to that. Is there any way that I can change this behavior ? 

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
v-jianhe-msft Regular Visitor
Regular Visitor

Re: relative date filtering

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

View solution in original post

1 REPLY 1
v-jianhe-msft Regular Visitor
Regular Visitor

Re: relative date filtering

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

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,340)