Forum Discussion
How to clear single selection visual data filter?
Hi, it's my first time here.
I'm learning Power BI, and I have a question. I have created a visual data filter to display sales for each salesperson. I chose single selection in the formatting pane. Now, if I need to clear the selection and view everyone's sales, how can I do that? Is it possible to insert an "All" button?
Clear Filter Button: You can add a button that clears all filters on the page. To do this:
Go to the "Insert" tab.
Select "Button" and choose a button style.
Place the button on your report.
With the button selected, go to the "Action" pane.
Turn on the "Action" toggle.
Set the "Type" to "Bookmark".
Create a bookmark that has no filters applied and link the button to this bookmark.Or
Slicer with "Select All" Option: If you are using a slicer for filtering, you can enable the "Select All" option:Click on the slicer visual.
Go to the "Format" pane.
Under "Selection controls", turn on the "Select all" option.
This will add a "Select All" option to your slicer, allowing you to clear the selection and view all data.
3 Replies
- bhanu_gautam
Super User
Clear Filter Button: You can add a button that clears all filters on the page. To do this:
Go to the "Insert" tab.
Select "Button" and choose a button style.
Place the button on your report.
With the button selected, go to the "Action" pane.
Turn on the "Action" toggle.
Set the "Type" to "Bookmark".
Create a bookmark that has no filters applied and link the button to this bookmark.Or
Slicer with "Select All" Option: If you are using a slicer for filtering, you can enable the "Select All" option:Click on the slicer visual.
Go to the "Format" pane.
Under "Selection controls", turn on the "Select all" option.
This will add a "Select All" option to your slicer, allowing you to clear the selection and view all data.Thanks for the quick reply bhanu_gautam.
I know the first method did you have explained.
Intead, the second is possible only if I deselect the single selection option.
Sorry maybe I didn't express myself well. It's possible to add a selection in the visual data filter that clear all filters selected or select every salesperson, or not?
