Forum Discussion
Date Slicer doesn't default to latest date
Hi , Charles-CW
Based on your error scenario, I suspect that your slicer is placing dates from the fact table, not from the date table, because if your report is published to the Power BI service and the data is not refreshed, your date values from the fact table will not appear later than the date values published to the Power BI service, which results in the maximum date value displayed in your slicer can only be the date value at the time of publishing.
If convenient, you can click the "Refresh now" button for the corresponding dataset in the report to trigger a data refresh, and then check if the maximum date value of the slicer is updated.
If not, you can also click Refresh in the upper right corner of the report to see if the data is updated.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Microsoft - do you realize that you are making us developers look like idiots to our business users, when we train them to understand that the slicer date range will automaticlly adjust to the most recent data, and then, FOR NO GOOD REASON, you decide to change how that default works - WHY?