Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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:
Solved! Go to 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:
Create Multiple Slicers:
Group Each Slicer with a Corresponding Button:
Create Bookmarks for Each State:
Assign Bookmarks to Buttons:
Test the Setup:
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!
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:
Create Multiple Slicers:
Group Each Slicer with a Corresponding Button:
Create Bookmarks for Each State:
Assign Bookmarks to Buttons:
Test the Setup:
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!
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
83 | |
69 | |
68 | |
39 | |
37 |