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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 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.