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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.