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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
VK_nz
Helper I
Helper I

Button to click and present slicer options

Hi, 

 

I am looking to add a button which user can select then associated options would appear as slicer selection.

 

Below is example how may look, these are four buttons which presents seletion vlause when clicked:

Capture.JPG

1 ACCEPTED SOLUTION
grazitti_sapna
Super User
Super User

Hi @VK_nz ,

The setup you are looking for, where clicking on buttons presents different slicer selections, can be accomplished in Power BI using the following method:

Approach to Implement Multiple Buttons for Slicer Visibility:

  1. Create Multiple Slicers:

    • Set up different slicers that represent the options you want to appear when a specific button is clicked.
  2. Group Each Slicer with a Corresponding Button:

    • Position the slicers on your report page and group each slicer with the respective button. You can do this using the Selection Pane:
      • Open the Selection Pane from the View tab.
      • Name each slicer and button for easier management.
  3. Create Bookmarks for Each State:

    • Use bookmarks to save the state of the report when each button is clicked.
    • For example:
      • Bookmark 1: Slicer 1 is visible, and other slicers are hidden.
      • Bookmark 2: Slicer 2 is visible, and the rest are hidden.
      • Repeat for all the slicer-button pairs.
    • Make sure to check only "Selected Visuals" when creating the bookmarks, so only the slicer visibility is affected.
  4. Assign Bookmarks to Buttons:

    • Select each button, enable the Action feature from the Formatting pane, and set the action type to Bookmark.
    • Assign the respective bookmark to each button.
  5. Test the Setup:

    • Click each button to ensure it shows the desired slicer and hides the others.

This way, each button will present the appropriate slicer when clicked, as illustrated in the example you've shared.

You May Also Reffer to the Link : Link To YouTube 

If I have resolved your question, please consider marking my post as a solution🎉. Thank you!

 

View solution in original post

3 REPLIES 3
grazitti_sapna
Super User
Super User

Hi @VK_nz ,

The setup you are looking for, where clicking on buttons presents different slicer selections, can be accomplished in Power BI using the following method:

Approach to Implement Multiple Buttons for Slicer Visibility:

  1. Create Multiple Slicers:

    • Set up different slicers that represent the options you want to appear when a specific button is clicked.
  2. Group Each Slicer with a Corresponding Button:

    • Position the slicers on your report page and group each slicer with the respective button. You can do this using the Selection Pane:
      • Open the Selection Pane from the View tab.
      • Name each slicer and button for easier management.
  3. Create Bookmarks for Each State:

    • Use bookmarks to save the state of the report when each button is clicked.
    • For example:
      • Bookmark 1: Slicer 1 is visible, and other slicers are hidden.
      • Bookmark 2: Slicer 2 is visible, and the rest are hidden.
      • Repeat for all the slicer-button pairs.
    • Make sure to check only "Selected Visuals" when creating the bookmarks, so only the slicer visibility is affected.
  4. Assign Bookmarks to Buttons:

    • Select each button, enable the Action feature from the Formatting pane, and set the action type to Bookmark.
    • Assign the respective bookmark to each button.
  5. Test the Setup:

    • Click each button to ensure it shows the desired slicer and hides the others.

This way, each button will present the appropriate slicer when clicked, as illustrated in the example you've shared.

You May Also Reffer to the Link : Link To YouTube 

If I have resolved your question, please consider marking my post as a solution🎉. Thank you!

 

FarhanJeelani
Super User
Super User

It seems you're aiming to add interactive buttons in Power BI that act as slicers to display associated options when clicked, similar to the example image.

 

Here's a general approach you can follow:

 

1. Create Individual Buttons for Each Category:
- Go to the Insert tab in Power BI, and add Buttons.
- Create a separate button for each category (e.g., "Network," "Option 2," "Option 3," etc.).

 

2. Use Bookmarks and Selection Pane:
- Set up bookmarks for each category that display the relevant slicers or visuals when the corresponding button is clicked.
- Arrange your slicers in the report, hiding or showing each based on the bookmark.
- Go to the View tab and open the Selection Pane to control visibility. For each bookmark, show only the relevant slicer and hide others.

 

3. Assign Bookmarks to Buttons:
- Select each button, go to the Format options, and assign a specific bookmark to each button under Action settings.
- This way, when a button is clicked, the associated slicer will appear.

 

4. Test the Interaction:

- Test clicking each button to ensure it only displays the associated slicer options, keeping others hidden.

This method leverages Power BI’s bookmarks and selection features to mimic a button-based slicer interface for improved user experience. Let me know if you need more specific guidance on any of these steps!

Thank you

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.