Button to click and present slicer options

[VK_nz]

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:

[grazitti_sapna · Accepted solution]

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]

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!

[VK_nz]

Thank you