Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Anonymous
Not applicable

Button that switches between two slicer styles

I want to include a button that switches between two slicer styles (Between and Relative Date).

Meaning going from this:

MagnusErler_0-1674483474673.png

To this:

MagnusErler_1-1674483531218.png


When clicking on Relativ the slicer style changes to relative.

Thank you

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

Add your date slicer to the page and set it to range.

Create a bookmark on the page and name it Range.  Then change the bookmark to Data, Current Page, and Selected visuals:

jdbuchanan71_0-1674484335603.png

Select the date slicer and then update the bookmark.  This will set the bookmark to only point at the date slicer (selected visuals).

 

Change the date slicer to Relative and sent the default range like Last 12 Months.

Add another bookmark and name it Relative then set it the same way Data, Current Page, and Selected visuals.

Select the date slicer then update the 2nd bookmark.

Add both bookmarks to a group by selecting them both in the boomkarks list with shift+click then right click and group.  Name this something like Dates

Add a bookmark navigator button to the page and pick the Dates bookmark group to show on the button. 
I attached a gif of the process you can take a look at.

View solution in original post

1 REPLY 1
jdbuchanan71
Super User
Super User

Add your date slicer to the page and set it to range.

Create a bookmark on the page and name it Range.  Then change the bookmark to Data, Current Page, and Selected visuals:

jdbuchanan71_0-1674484335603.png

Select the date slicer and then update the bookmark.  This will set the bookmark to only point at the date slicer (selected visuals).

 

Change the date slicer to Relative and sent the default range like Last 12 Months.

Add another bookmark and name it Relative then set it the same way Data, Current Page, and Selected visuals.

Select the date slicer then update the 2nd bookmark.

Add both bookmarks to a group by selecting them both in the boomkarks list with shift+click then right click and group.  Name this something like Dates

Add a bookmark navigator button to the page and pick the Dates bookmark group to show on the button. 
I attached a gif of the process you can take a look at.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.