Between Day slicer does not update the newest day in data set

[HaiVN]

Hello community,

I have a report wich I use the betwwen day slicer. data set in Sharepoint and  is updated automatic each 7 days. The report is updated every day. The problem is the report get all newest data in from data set but the betwen time slice does not update to the newest day in the data set. I have to update the slice by hand each 7 day. I wonder if it has a method for slicer to update automtic  the last day i the data set ?

Thank you!

[Shahid12523]

Problem: "Between" date slicer doesn’t auto-update to the latest date after refresh.

Fixes:
- Use Relative Date slicer – auto-updates based on last X days/weeks.
- Create DAX filter – only show dates ≤ latest date in dataset.
- Use MAX(Date) measure – to drive dynamic filtering (not slicer default).
- Bookmark workaround – semi-automated, needs manual refresh or scripting.

[HaiVN]

@Shahid12523 
THanks for your message ! 
Problem is that I want to offer the user  to choose the data between to dates i the past. Not last  N days . For example : data sett is updatet to 2.sep.2025 but user can choose the data from 1.1.2024 to 15.9.2024 ?

[MasonMA · Accepted solution]

@HaiVN 

Create one Calculated column to be used as flag with below DAX (Adjust your relative days in the Measure)

SWITCH(
    TRUE(),
    Date_MasterTable[Date]>= DATE(2025,1,1) && Date_MasterTable[Date] <= TODAY() +15, 1,
   0
)

And apply the flag Measure as a visual-level filter on your Date slicer. 

[v-menakakota]

Hi @HaiVN , 

Thanks for reaching out to the Microsoft fabric community forum. 

The Between slicer will not update to the newest date automatically it always keeps the last values you selected. If you want the dates to move forward with each refresh, you need to use a Relative Date filter/slicer ( Last 7 days or Last 1 day with Include Today checked).

Please through the below document which may help you in resolving the issue:

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

Best Regards, 
Community Support Team  

[v-menakakota]

Hi @HaiVN ,

Can you please confirm whether the issue is sorted or not.

Thank you.

[v-menakakota]

Hi @HaiVN ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team 

[v-menakakota]

Hi @HaiVN ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team 

[danextian]

Hi @HaiVN 

I am unclear whether want the slicer to dynamically change to the last 7 days with each refresh or for the range to include all dates. If the  latter,  ensure you've cleared the slicer prior to publishing it. Report users in the Service also need to do the same if persistent filter is enabled.

[apmonisha]

Thanks for the question.

If you preselect the date in the between slicer, it will not automatically update. I would recommend clearing the filter 

Second step: add that column into the filter pane, and selected the first date of the between so user have a preselected from and they can just select the to or vice versa

[apmonisha]

That is the correct relative date option. For today, you need to check 'includu today'

[MasonMA]

Hello @HaiVN 

Please refer to this post below:) 

https://community.fabric.microsoft.com/t5/Service/Date-slicer-does-not-update-after-refresh-in-Servi...

'If you want the "To" date to update daily in Service, use relative date filters like today last 1 day in the filter pane, not in the slicer with fixed values. make sure your dataset refresh is happening properly in the Service. The slicer does not reset itself to a fresh date after refresh it keeps the selection made earlier unless you use measures or relative filters'

Hope this helps:) 

[HaiVN]

@MasonMA 
Thank you for your answer. 
I wonder you can explain me a little bit more. I can not find the the 'today last 1 day' in the filter pane!

[Aburar_123]

Hi @HaiVN ,

you just have to select the 'Include Today' option along with Last 1 day selection in the filter as below,

[MasonMA]

@HaiVN 

For Relative Date slicer/filter setup tutorial please refer to Microsoft document here, 

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range.

In my understanding, if you switch to Relative Date slicer you may lose the flexibility of a manual 'Between slicer' where your users can pick any arbitrary start and end dates.

Or you keep the Relative Date filter at the report/page level (so it always moves forward), and still place a Between slicer on the report for user exploration, but limit it to be within the relative filter window. This way, users can adjust within a rolling window, but I doubt if the “To' Date automatically updates itself in service because Power BI Date Slicer normallly remembers users' lasted selected Date. 

[apmonisha]

Can you select the slicer and in the filter pane of the slicer - fix the start date.

Also clear the filter on top of the slicer

If you have preselected the value of between in the slicer, it wouldn't change automatically 

Hope it helps!

Please let me know if you have any questions.