cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mahitham Regular Visitor
Regular Visitor

Clear All Slicers by one button in power bi desktop ?

Hi Community,

 

Is there any way to clear all the selected Records in the Slicers by one click on Power BI desktop.

In qliksense there is Global Clear All option within desktop. Do we have this oprion in Power Bi desktop.

 

Please let me know.

 

Thanks in advance.

 

clearall.png

1 ACCEPTED SOLUTION

Accepted Solutions
Thejeswar Senior Member
Senior Member

Re: Clear All Slicers by one button in power bi desktop ?

Hi,

Find the below images showing the same

 

1.The Report is created with a slicer present for making selections

Report1.PNGReport with Slicer

 2. The Below image shows the way to add Bookmark in the report

 

Report2.PNGAdding Bookmark

 3. Once an image is added,

1. Click on the image.

2. An Action Option will be visible in the Properties pane.

3. There set the type as Bookmark and in Bookmark section select the Bookmark present in the report

 

report4.PNGAssigning Bookmark to Image

 In Power BI Desktop, Ctlr+Click on the image for the Bookmak to work. In PBI Service, a simple click is enough for it to work

 

Click here to get the PBIX file with Bookmarks implemented. Hope this helps!!!

 

 

7 REPLIES 7
Thejeswar Senior Member
Senior Member

Re: Clear All Slicers by one button in power bi desktop ?

Hi @mahitham,

There is no any direct way to clear all the Slicer selections at one shot.

 

Instead you can achieve it by an alternative way

 

1. Create a bookmark with the view similar to the report. (No Slicer should be selected with creating the Bookmark i.e. Full data should be displayed)

2. Provide an image as "Clear Filters" and make that image to render your bookmark.

 

Bookmarks by default does not hold the slicer selections made in the report

mahitham Regular Visitor
Regular Visitor

Re: Clear All Slicers by one button in power bi desktop ?

Hi,

 

I am new to Power BI. Could you Please add the Screen shots for implemeting.

I have found Book Mark Pane under View Ribbon.

 

Thanks

Thejeswar Senior Member
Senior Member

Re: Clear All Slicers by one button in power bi desktop ?

Hi,

Find the below images showing the same

 

1.The Report is created with a slicer present for making selections

Report1.PNGReport with Slicer

 2. The Below image shows the way to add Bookmark in the report

 

Report2.PNGAdding Bookmark

 3. Once an image is added,

1. Click on the image.

2. An Action Option will be visible in the Properties pane.

3. There set the type as Bookmark and in Bookmark section select the Bookmark present in the report

 

report4.PNGAssigning Bookmark to Image

 In Power BI Desktop, Ctlr+Click on the image for the Bookmak to work. In PBI Service, a simple click is enough for it to work

 

Click here to get the PBIX file with Bookmarks implemented. Hope this helps!!!

 

 

mahitham Regular Visitor
Regular Visitor

Re: Clear All Slicers by one button in power bi desktop ?

Thanks alot for your clear Explanation Smiley Happy

pobilearner Frequent Visitor
Frequent Visitor

Re: Clear All Slicers by one button in power bi desktop ?

I am able to reset the slicers but along with slicers, I want to filter out the text that I added to the Slicer by using the feature of Search. Is it possible to remove both slicer selection and search text in one go itself?

Highlighted
jmolson2013 Frequent Visitor
Frequent Visitor

Re: Clear All Slicers by one button in power bi desktop ?

This is PERFECT - I spent a day searching for the reason why clear filter button was not working.. when I believed to be doing the right thing - only to find out (get this) - you need to hold down the control key while hitting the "button" in the desktop version, and only hit the "button" in the web (published) version.  Thanks so much  Thejeswar!!!!  Truly appreciated!

Thejeswar Senior Member
Senior Member

Re: Clear All Slicers by one button in power bi desktop ?

I had already specified ctrl + click inDesktop while a simple click in Web Version for the button to work Smiley Very Happy