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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
da26
Frequent Visitor

date value of slicer visual not updating after the scheduled refresh

Hi!

We have a report in power bi that is scheduled refresh daily and connects on-premise data source. After the refresh was made, the date value in slicer visual is still not updating. We still need to manually refresh the page before the changes take effect. 

 

For example, we publish the report yesterday (02-21-2017), and the data is refreshed today, the latest value of the date in slicer must be 02-22-2017 but the changes do not take effect. This issue is encountered in Service but in Desktop, it works fine.

 

Thanks for your response. 🙂

 

 

1 ACCEPTED SOLUTION

Hi @da26

 

Could I ask a question for on your Date Slicer, is a date range specifically selected? 

 

The reason I ask is if you had to remove the Date slicer, and just put in a Card which has the latest date, and refresh your data, does the card reflect the latest date?

 

If it does then the process is working as expected and it is that there is a selection on the Date Slicer that is causing it now to show the updated data correctly.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

24 REPLIES 24

@CL2316Nope, have been working with microsoft support on this for months. So far their response is thats how its intended to work and I need to manually update my report EVERY DAY to update the default slicer value. Frustating that they can just mark these threads as "resolved" without proving a solution and then ignoring further comments for eternity. Will let you know if I get any solution from support.

Thanks for getting back to me! I think I've found some kind of solution. I opened the report on PowerBI Desktop app, deleted the slicer, added a new slicer and added the date column as usual. Then I republished the report without touching the slicer.

 

Whenever the report is refreshed, the slicer now automatically updates to show the most recent data e.g. on 18th Jul, the max date on the slicer was 17th Jul. The data refreshed overnight, now on 19th Jul, the max date on the slicer is 18th Jul which is what i wanted.

I think if you start editing the slicer after it's made, it's classed as filtered even if all the dates are eventually selected. E.g. if you have a Between slicer and you filter it to last 24M. If you then drag it to the min and max, it's still been edited somehow by a human.

Hey I appreciate the work around. It sort of works but unfortunately not for my scenario.

 

The default date range now updates, however that date range is actually not being applied by default until an end user interacts with the slicer.

 

For example if you have a fact table that has a larger date range than your date table, previously the date slicer would limit the fact table to that range. Now no time restrictions at all are passed by default, despite the date slicer showing a limited range. The moment when the end user first adjust the date slicer is when those values are actually passed to the dashboard. So I have data that is outside the default date range leaking in. Good news is I can develop around it but its something to be aware of.

Any progress on this - same problem. Date range is not applied until the user clicks on both of the ends of the slicer.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors