Home » Power BI » Clear All Slicers in Power BI

Clear All Slicers in Power BI

Clear All Slicers in Power BI

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

Note:




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:

Visuals

Visuals




Step-2: Go to Home menu & under Insert ribbon click on Button & select Blank.

Power Bi Button

Power Bi Button

Step-3: Now change button name, Select blank button then under Visualizations Pane give name to button.

Button Properties




Step-4: Now create bookmark for button, Go to View Menu & check Bookmarks Pane, then click to Add button.

Power Bi Bookmark

Step-5: Rename the bookmark.

Rename Bookmark

Rename 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

 

Power Bi Action




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.



Leave a Reply