Button to go back to most recent date loaded

[f_r_1998]

Hi everyone,

for my dashboard I need to add a button that "resets" the page and gets rid of all filters selected to show the page in its "original" state. I know that this is possible with a simple bookmark, however this button should also always jump to the most recent date (I have a slicer where the user can choose the month he or she wants to see). And since for example right now the most recent month loaded is April, the bookmark would be saved like that. So in the future when clicking the reset button, it would go to the month of April even though there would be a more recent month. Is there a way to configure this? So basically make the button dynamic and not static.

Also, the slicer has the single - select configuration, so I am not able to have no selection and make the bookmark based on that. 

Thanks for your help!

[Anonymous · Accepted solution]

Hi @f_r_1998

It looks like you need a combination of the solution from below blog and the bookmark. Have a "Latest month" option selected by default in a slicer and create a boomark to store the status. Then add a button and bind it to the bookmark. This should bring you the expected behavior. 

How to dynamically select the default values we need in a slicer in Power BI

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[PijushRoy]

Hi @f_r_1998 

That means, you want to reset all the slicer but Month slicer should show current month.
For example, in Sep month, all slicer should reset but month slicer should show Sep not April
Please confirm

[f_r_1998]

Yes exactly. So the filters should be reset in original state and the date filter set to most recent date avalaible (so basically the first one in the selection, since the slicer is structured hierarchly). Do you know whether there is any way to do this?