Forum Discussion
Advocate IDate Slicer not Responsive to Calculated Date Table
Hello,
I have a data slicer configure for in between dates. The slicer is based off of a calulated date table. The max date of the date table is derived from the maximum created date in the SharePoint list. The calulated date table updates accurately when refreshing the data but the slicer control does not update its max date and the slider doesn't slide all the way to the right on refresh. How can I make sure the slicer control updates appropriately.
FY Table =
ADDCOLUMNS(
ADDCOLUMNS(
CALENDAR(MIN('Action Items'[Created Date]),MAX('Action Items'[Created Date])),
"Year", YEAR([Date]),
"Month Number", MONTH([Date]),
"Month Name",FORMAT([Date],"mmmm"),
"Day of Week",FORMAT([Date],"dddd"),
"Day Number", DAY([Date])
),
"Fiscal Year", IF(MONTH([Date])>=7, YEAR([Date])+1, YEAR([Date])),
"Fiscal Quarter",SWITCH(
TRUE(),
AND(MONTH([Date])>=7, MONTH([Date])<=9),1,
AND(MONTH([Date])>=10,MONTH([Date])<=12),2,
AND(MONTH([Date])>=1,MONTH([Date])<=3),3,
AND(MONTH([Date])>=4,MONTH([Date])<=6),4),
"Fiscal Month Number",IF(MONTH([Date])>=7, MONTH([Date])-6,MONTH([Date])+5)
Hi FAW71,
Your calculated Date table is probably updating correctly. The issue is usually that the Between slicer keeps its saved selection state.
The slicer does not always automatically move its right handle to the new max date after refresh, even if the Date table now contains later dates.
A few things to try:
- Clear the slicer before publishing
In Power BI Desktop, clear the date slicer selection or use Clear all slicers, then save and publish again.
- Delete and recreate the slicer
If the slicer state is stuck, deleting and recreating the slicer can reset the stored range.
- Use a helper filter instead of relying only on the slicer handle
Create a calculated column in your Date table:
Dates With Data = IF ( 'FY Table'[Date] <= CALCULATE ( MAX ( 'Action Items'[Created Date] ), ALL ( 'Action Items' ) ), 1, 0 )Then add Dates With Data = 1 as a page or visual filter. This keeps the slicer limited to dates that exist in your data.
- Consider Relative Date / Date Picker slicer
If the goal is always to show the latest available date or today, the Relative Date or Date Picker slicer may be more reliable than a manually saved Between slicer.
Reference:
🔍Parchitect
Solutions Architect · Microsoft Fabric Specialist💡Helpful? Kudos are appreciated.
✔️Solved? Mark as Solution so others can find it faster.- Clear the slicer before publishing
Hi FAW71,
Yes, it's known — but by design rather than a bug.Once you move the handles on a Between slicer, that range is saved into the report definition as an intentional default. Microsoft's troubleshooting docs address this directly and recommend clearing range slicers and saving in that cleared state before publishing — a cleared slicer follows your data after refresh, a touched one keeps the saved range.
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-troubleshootAlso note Persistent filters in the Service (on by default): it reapplies each user's last selection, so users may still see a stale range until they hit Reset to default.
The good news: the new Date picker slicer (preview) was built for exactly this. It keeps the slider and calendar UX, but supports relative selections anchored to Last date — the most recent date in your date column. Since your max comes from the latest Created Date in SharePoint, the range follows your data automatically after each refresh. Enable it under Options > Preview features.
https://learn.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
7 Replies
- Parchitect
Solution Sage
Hi FAW71,
Your calculated Date table is probably updating correctly. The issue is usually that the Between slicer keeps its saved selection state.
The slicer does not always automatically move its right handle to the new max date after refresh, even if the Date table now contains later dates.
A few things to try:
- Clear the slicer before publishing
In Power BI Desktop, clear the date slicer selection or use Clear all slicers, then save and publish again.
- Delete and recreate the slicer
If the slicer state is stuck, deleting and recreating the slicer can reset the stored range.
- Use a helper filter instead of relying only on the slicer handle
Create a calculated column in your Date table:
Dates With Data = IF ( 'FY Table'[Date] <= CALCULATE ( MAX ( 'Action Items'[Created Date] ), ALL ( 'Action Items' ) ), 1, 0 )Then add Dates With Data = 1 as a page or visual filter. This keeps the slicer limited to dates that exist in your data.
- Consider Relative Date / Date Picker slicer
If the goal is always to show the latest available date or today, the Relative Date or Date Picker slicer may be more reliable than a manually saved Between slicer.
Reference:
🔍Parchitect
Solutions Architect · Microsoft Fabric Specialist💡Helpful? Kudos are appreciated.
✔️Solved? Mark as Solution so others can find it faster. - Clear the slicer before publishing
FAW71So this is a known issue for date slicers? This stinks becasue the between slicer is a nice capability and easy for the end user to understand and use.
- Parchitect
Hi FAW71,
Yes, it's known — but by design rather than a bug.Once you move the handles on a Between slicer, that range is saved into the report definition as an intentional default. Microsoft's troubleshooting docs address this directly and recommend clearing range slicers and saving in that cleared state before publishing — a cleared slicer follows your data after refresh, a touched one keeps the saved range.
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-troubleshootAlso note Persistent filters in the Service (on by default): it reapplies each user's last selection, so users may still see a stale range until they hit Reset to default.
The good news: the new Date picker slicer (preview) was built for exactly this. It keeps the slider and calendar UX, but supports relative selections anchored to Last date — the most recent date in your date column. Since your max comes from the latest Created Date in SharePoint, the range follows your data automatically after each refresh. Enable it under Options > Preview features.
https://learn.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range- FAW71
I don't have the preview option of Date picker slicer in my BI desktop. I will have to see if IT has an updated version of PBI Desktop to get the new (preview) features.
- Shahid12523
Community Champion
The calculated date table updates correctly, but the 'Between' date slicer still shows the previously selected range and does not automatically extend to the new maximum date.
v-sathmakuriCommunity Support
Hi FAW71 ,
Thank you for reaching out to fabric community.
Could you review the suggestion provided by Shahid12523 , danextian and Parchitect let us know if you have any additional questions, we are happy to address.
Thanks!!
