Good day, I have a date slicer (Between) on my reports. The slicer is set to filter by Relative date and defaulted to the last 12 months including today.Previously in BI Service this would automatically update to today but it no longer does and the report defaults to the date that was selected when the report was published. How can I get BI Service to update to today?

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?

Thanks for the resarch Charles. funny we need to vote on returning functionality that has been there for at least 5 years. 🙂

andymc123 , I have logged a support ticket with Microsoft. Still awaiting feedback. I will update the post as soon as I get some feedback.

Hi andymc123 , v-yueyunzh-msft ,Microsoft replied and suggested that this be raised as an idea and that the community would need to vote on this. Microsoft support raised the idea on my behalf. Kindly please follow the below link to vote for this to be fixed.Microsoft Idea

Hi v-yueyunzh-msft, Thank you for the detailed explanation but it still does not resolve my issue. I am currently supporting 8 different reports with date slicers, and I am currently logging into each report daily and manually updating the date which is becoming a tedious and timely task. I am sure that was automatically updating previously as I never had to do it in the past and it was always on the latest date in BI Service.

Date Slicer doesn't default to latest date | Microsoft Fabric Community

18 Replies

Cyp79
New Member
2 years ago
Hi,
I have the same issue. It was perfectly working since I started using PBI 5 years ago. But now the feature is gone.
It is critical because I've got 20+ dashboards updating automaticaly every single day and I can't manually change the date. That's wierd because some dashboards I didn't modify recently are still refreshing the last date... So I tried hard to understand what I did wrong on the dashboards I modified, but it seems it is a just downgrade of PBI.
Please fix this problem and as fast as you can.

Best
HLandry73
Frequent Visitor
2 years ago
I am really stunned that this functionality is not available. This is basic in other dashboarding tools and is yet another reason that I feel Power BI is not the best when it comes to enterprise wide BI.
v-yueyunzh-msft
Community Support
3 years ago
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
- Anonymous
  Not applicable
  3 years ago
  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?
Charles-CW
Advocate I
3 years ago
v-yueyunzh-msft, thank you for the response.

The model I build and the slicer uses a Date Table. The model is also built in a tabular model and deployes to SSAS where I have a direct connection to my reports so I don't need to refresh the report as it automatically refreshes.
- v-yueyunzh-msft
  Community Support
  3 years ago
  Hi , Charles-CW
  
  Based on your current issue description, you are using the Slicer core visual in your Power BI report, it binding with date table and will be refreshed with latest date info, the refresh scheduled twice per day.
  
  But the Slicer range end date will by default keep the same as which you publish the report, you expected to be the latest available date.
  
  We did some test from our side with simple test data, and date table defined with ‘Calendar = calendar(min(Sheet1[date]),MAX(Sheet1[date]))’.
  
  we get the result that this is by design if you have selections defined in your slicer, it will keep that selection by default, can only be updated manually.
  
  But if you clear selection in your report definition, for example click the Clear selections button in report edit mode:
  
  After updated with some rows in the data source:
  
  It will auto updated to latest available end date after click model refresh from Power BI desktop:
  
  So we suggest that when you develop the report from PBI desktop, clear selection for this Date between style slicer before you publish it to service.
  
  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
  - Charles-CW
    Advocate I
    3 years ago
    Hi v-yueyunzh-msft,
    
    Thank you for the detailed explanation but it still does not resolve my issue.
    
    I am currently supporting 8 different reports with date slicers, and I am currently logging into each report daily and manually updating the date which is becoming a tedious and timely task.
    
    I am sure that was automatically updating previously as I never had to do it in the past and it was always on the latest date in BI Service.
Anonymous
Not applicable
3 years ago
Hi, Charles-CW,

I now face the same issue as you rasied, may I know have you found an alternative solution? Advance thank for your response.

Best regards,
Esther
- Charles-CW
  Advocate I
  3 years ago
  Hi Anonymous,
  
  Unfortunately I have not found an alternative solution other than updating it manually daily.
  
  Please do vote for this to be fixed - https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=6544db08-0606-ee11-a81c-000d3a0ec312
M-M-P
Helper III
2 years ago
I maintain 50+ reports and get daily questions from our customers about when they get new data from us and why our service is down.
I'm running out of professional answers.

Microsoft - We trust that you at least maintain a status quo in relation to features.
Please vote