Relative Date Filter behaving oddly

[Anonymous]

I hope someone can explain this to me. I am filtering a Matrix to show the previous day's data with a filter of in the last 1 days with the Include today box unchecked.

This morning everything was working fine. I closed my project before lunch and when I reopened it this afternoon, the relative filter is returning today's date even though Inculde today is still unchecked. It's almost like the control is living in a different time zone!

This is what I'm seeing on 12/17/2019, the Activity_Date should have a 12/16/2019-12/16/2019 range, not 12/17.

Image taken at 4:45pm PST on 12/17 it should show 12/16/2019 as the target date

[parry2k · Accepted solution]

@Anonymous most likey it is UTC time zone and tha'ts why it changed.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

The following limitations and considerations currently apply to the relative date range slicer and filter.

• Data models in Power BI don't include time zone info. The models can store times, but there's no indication of the time zone they're in.

• The slicer and filter are always based on the time in UTC. If you set up a filter in a report and send it to a colleague in a different time zone, you'll both see the same data. Unless you are in the UTC time zone, you and your colleague must account for the time offset you’ll experience.

• You can convert data captured in a local time zone to UTC using the Query Editor.

You might refer to this articles for more reference about the timeset in power bi and the proper solution: 

https://radacad.com/solving-dax-time-zone-issue-in-power-bi 

https://www.fourmoo.com/2017/10/03/power-bi-did-you-know-all-power-bi-services-servers-are-in-utc-now-how-to-handle-it-for-dates-times/ 

[parry2k · Accepted solution]

@Anonymous most likey it is UTC time zone and tha'ts why it changed.