Clear All Slicers in Power BI

Using Power BI Bookmark & Button you can clear multiple slicers selected values in one click.

Note:

• Download Sample Dataset: Excel Sample Dataset for practice

Situation:

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.