cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

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.

fastdatesetting.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver IV
Resolver IV

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

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!

View solution in original post

2 REPLIES 2
Highlighted
Resolver IV
Resolver IV

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

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!

View solution in original post

Highlighted
Resolver IV
Resolver IV

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

@ale-hd any luck on this?

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors