Clear all slicers must return d-1 values

[julsr]

Hello everyone,

I'm implementing the button "Clear all slicers" but this returns as default the first date of my dataset. How can I ensure that once this button is clicked, the values will always be D-1 (Today's Date -1)?

Thanks

[Greg_Deckler]

@julsr You would want to have a day offset in your Date/Calendar table. Then you could create a bookmark for that where the page is filtered to the offset equal -1. Clear all slicers could then just invoke that bookmark.

[julsr]

Thanks for your answer! I'm using the following logic: https://www.linkedin.com/pulse/power-bi-single-date-picker-without-dax-torsten-wanka/ to have a single date picker in my dashboard, but when I want to apply something to show the last day value in my code, it doesn't work. I expected to see the last day with this and use it as a bookmark.

[Anonymous · Accepted solution]

Hi @julsr ,

Try using a custom visual “pre-selected slicer” and bookmarks for a similar result:

The pre-selected slicer's interaction with the built-in slicer is turned off by default, so please remember to turn on the interaction.

Change how visuals interact in a report - Power BI | Microsoft Learn

Hide pre-selected slicer when saving bookmarks.

I've made a simple example that I hope helps.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum