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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MagnusErler
Helper I
Helper I

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors