Forum Discussion

Siddharth36's avatar
Siddharth36
New Member
1 year ago
Solved

In Between Date Slicer Rest

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...
  • saritasw's avatar
    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 

     

     

  • mdaatifraza5556's avatar
    1 year ago

    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.