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 Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)