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,
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.