date value of slicer visual not updating after the scheduled refresh

[Anonymous]

Hello, I am using the slicer of Power BI. I am publishing a Power BI report to a dashboard and running a scheduled job. However, when I use the Between Range slicer, the data is not selected up to the latest date when the data is refreshed.

For example, the report below is mine. If I refresh it tomorrow, the Raw data will be loaded up to 4/11, but the slicer will select the data up to 4/10, making it look like it hasn't been updated and i must update manual Report. Is there a way to automatically change the Right date when refreshing by using the slicer in a range format?

[Alastair101]

I have done some testing on this as it has been affecting our dashboards and it is very frustrating to delete slicers and re-instate or jump through hoops to get things to work.

The solutiuon that appears to work for me is the new 'Clear all Slicers' button. Using this before publishing on every page which has date slicers appears to ensure that the slicer refreshes and updates on the service as expected. So the process is;

1/ On the desktop test and use the slicers as required.

2/ Prior to publishing use the 'clear all slicers' button. To reset these date slicers.

If slicers are synced across multiple then just resetting on one of pages appears to work.

If you have other slicers that need to have defined selection you can do this after step 2. Just dont adjust the date slicer.

If the clear all slicers button is not a required feature on a page then having as a hidden element for dev purposes is a good approach.

[Stoppelaar]

Thanks @Alastair101 ! 

Question, lets say my date range is 5 years and I want to make it "easier" for my users, so the start date should be 1/1/2025 to the last end date, any solution on this? 

Been trying and searching but cant find a solution 😞 

[johncpratt]

"Clear all Slicers" worked for me to fix a nagging issue with a date slicer.  Thank you! I ended up adding the button, clicking it, then deleting it since I already had a separate clear button for the bookmarks.

I can add to the solution regarding bookmarks.  I have page-level bookmarks used for a "Clear all Filters" button on each page, and these were not fixed using the "Clear all Slicers" button on one page.  What I had to do is add the "Clear all Slicers" button to each page, click it, delete it, then update the page-level bookmark.

[Anonymous · Accepted solution]

HI @Anonymous,

Perhaps you can try to create a calculate table based on calendar function and use the correspond start date and today function as parameters.

You can use this table date field as source of slicer and its default select ranges will be the start date to today. (its end date will change when system date updated and calculate table recalculated)

Regards,

Xiaoxin Sheng