Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

date value of slicer visual not updating after the scheduled refresh

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?

 

dklsansalvfal_1-1681280632484.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

3 REPLIES 3
Alastair101
Frequent Visitor

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.


"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
Not applicable

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors