Forum Discussion
In Between Date Slicer Rest
- 1 year ago
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 - 1 year ago
Hi Siddharth36
Can you please try the below steps
Create caculated col using the daxset the visual level and set true.
If this answers your questions, kindly accept it as a solution and give kudos.
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.