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!!!

 

 

View solution in original post

8 REPLIES 8
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!!!

 

 

View solution in original post

mahitham Regular Visitor
Regular Visitor

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

Thanks alot for your clear Explanation 🙂

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?

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!

Highlighted
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


mae101 Frequent Visitor
Frequent Visitor

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

Hi,

there is also a detailled tutorial available describing how to create such a button:

https://livingandcoding.com/blog/create-a-button-to-clear-all-filters-in-power-bi-in-4-easy-steps/

Regards

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors