cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Highlighted
Solution Sage
Solution Sage

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

Report with SlicerReport with Slicer

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

 

Adding BookmarkAdding 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

 

Assigning Bookmark to ImageAssigning 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
Highlighted
Solution Sage
Solution Sage

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

Highlighted
Helper I
Helper I

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

Highlighted
Solution Sage
Solution Sage

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

Report with SlicerReport with Slicer

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

 

Adding BookmarkAdding 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

 

Assigning Bookmark to ImageAssigning 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

Highlighted
Helper I
Helper I

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

Thanks alot for your clear Explanation 🙂

Highlighted
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
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
Solution Sage
Solution Sage

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


Highlighted
New Member

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 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors