Using Power BI Bookmark & Button you can clear multiple slicers selected values in one click.
- Download Sample Dataset: Excel Sample Dataset for practice
Suppose you have multiple slicers in your report page & each slicer you have select some values, now you want to clear all slicers selected values on one click.
Let’s understand with an example:
Step-1: Report Page visuals with multiple slicers as below:
Step-2: Go to Home menu & under Insert ribbon click on Button & select Blank.
Step-3: Now change button name, Select blank button then under Visualizations Pane give name to button.
Step-4: Now create bookmark for button, Go to View Menu & check Bookmarks Pane, then click to Add button.
Step-5: Rename the bookmark.
Step-6: Now link Bookmark with Button, Select Button from Page, then under Visualization Pane enable Action Pane & follow below properties
- Type: Select Bookmark
- Bookmark: Select Bookmark Name
Step-7: Now you can clear all selected slicers values on click of button. Use Ctrl+Click for button click.
Refer other Power BI topics: Power BI tutorials
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our Contact form , we will revert to you asap.