Set a slider date to "today" or other dates using buttons

[ale-hd]

Hi all, I have a slider with dates. On the report there is also a "last update" info.

I would like to insert a few buttons in order to allow a "fast" setting of the slider date, i.e. "click here to set today", "Click here to set last update" etc. etc. like in the enclosed image.

Do you know if it this possible and how to do it?

Thank you all, Alessandro.

[Anonymous · Accepted solution]

You can achieve this by creating custom columns in your date table:

One for each "fast setting", for example:

IsBeforeToday = if('Date'[Date] < TODAY() ; 1 ; 0)

IsBeforeLastUpdate = if('Date'[Date] < ["your last update field"]; 1 ; 0)

now you can create bookmarks, where each bookmark has different filters on the slicer eg;

Bookmark for today has a filter on the dateslicer (where isBeforeToday = 1)

When you click a button trigger the right bookmark and it should work!

[Anonymous]

@ale-hd any luck on this?