In Between Date Slicer Rest

[Siddharth36]

I have a requirement where I need to make sure that the slicer end date gets reset to the recent date after scheduled refresh, but right now it is stuck to consider the date with which the report was uploded.

I uploaded the report on 05/05/2025, and I had scheduled refresh everyday, but when report was opened on 05/10/2025, the date was still 05/05/2025, I want it to autoupdate to 05/10/2025.

[saritasw · Accepted solution]

Hi @Siddharth36, 

Slicers store user selection state when the report is saved or published, and Power BI doesn't dynamically change slicer selections after refresh. This behavior is by design.

To ensure the slicer automatically selects the most recent date in your data after each refresh,  create a DAX Measure with a Filter and Sync to a Slicer.
Create a measure for the latest date in your date column - 

LatestDate = MAX('YourTable'[DateColumn])
Otherwise, 
Create a Bookmark Button to Jump to Today or Latest. Since slicers don’t auto-update, a common practice is to use a button or bookmark to reset the filter to the latest date. Then train users to click "Reset to Today" if needed.
Create a measure that captures the most recent date.

LatestDate = CALCULATE(MAX('YourTable'[DateColumn]))
 *************************************************************************************************************************If If this solution worked for you, kindly mark it as Accept as Solution. This would be helpful for other members who may encounter similar issues and feel free to give a Kudos, it would be much appreciated!

Thank you,
Sarita 

[v-ssriganesh]

Hi @Siddharth36,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hi @Siddharth36,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-ssriganesh]

Hi @Siddharth36,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @mdaatifraza5556 & @saritasw for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solution? If so, please mark it as the solution. This will help other community members solve similar problems faster.

Thank you.

[mdaatifraza5556 · Accepted solution]

Hi @Siddharth36 

Can you please try the below steps

Create caculated col using the dax 

set the visual level and set true.

If this answers your questions, kindly accept it as a solution and give kudos.

[saritasw · Accepted solution]

Hi @Siddharth36, 

Slicers store user selection state when the report is saved or published, and Power BI doesn't dynamically change slicer selections after refresh. This behavior is by design.

To ensure the slicer automatically selects the most recent date in your data after each refresh,  create a DAX Measure with a Filter and Sync to a Slicer.
Create a measure for the latest date in your date column - 

LatestDate = MAX('YourTable'[DateColumn])
Otherwise, 
Create a Bookmark Button to Jump to Today or Latest. Since slicers don’t auto-update, a common practice is to use a button or bookmark to reset the filter to the latest date. Then train users to click "Reset to Today" if needed.
Create a measure that captures the most recent date.

LatestDate = CALCULATE(MAX('YourTable'[DateColumn]))
 *************************************************************************************************************************If If this solution worked for you, kindly mark it as Accept as Solution. This would be helpful for other members who may encounter similar issues and feel free to give a Kudos, it would be much appreciated!

Thank you,
Sarita