Forum Discussion
Relative date slicer does not work within a certain time when I refresh my dashboard
Hello, I have this relative date slicer that is set to last 2 days and it works when I refresh before about 4 pm but after that I need to change to last 3 days in order to get the data.
5 Replies
- PhilipTreacy
Super User
Anonymous
Hi,
On PBI Service?
What timezone is the Dashboard in? Check it is what you expect.
Regards
Phil
I’m using Power BI desktop. The first screen I sent was captured at 3/13/2021 at about past 1pm and the data is correct, relative date slicer last 2 days.
Now it is still 3/13/2021 7:40 pm, relative date slicer last 2 days and when I refreshed my data, it now shows blank. I'm expecting the result to be the same and shoud change it tomorrow 3/14/2021.
Hi Anonymous ,
The following limitations and considerations currently apply to the relative time slicer and filter.
Time zone considerations: 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 both see the same data. Unless you or your colleague are in the UTC time zone, you both must account for the time offset you’ll experience. Use the Query Editor to convert data captured in a local time zone to UTC.
This new filter type is supported in Power BI Desktop, the Power BI service, Power BI Embedded, and the Power BI mobile apps. However, it isn't supported for Publish to web.
Query caching: We use the client cache. Say you specify "last 1 minute," then "last 5 minutes," then back to "last 1 minute." At that point, you see the same results as when it was first run, unless you refresh the page or the page automatically refreshes.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
