Forum Discussion
Relative Date Filter behaving oddly
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
Anonymous most likey it is UTC time zone and tha'ts why it changed.
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
-
2 Replies
Anonymous most likey it is UTC time zone and tha'ts why it changed.
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
-