Clear All Slicers in Power BI; A Bookmark Story

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
FacebooktwitterlinkedinrssyoutubeFacebooktwitterlinkedinrssyoutube

Using bookmarks for clearing all slicers in Power BI is not a a new function, I have been using it for many months, and advising many people to do it that way. However, I still get a lot of questions in my presentations about how to do that. That is why I ended up writing this post. This post shows you a very quick trick of having a button to clear all slicers, and the magic is all happening with bookmarks. Bookmarks store the state of a Power BI page, and can be used in many scenarios, in this post, I only show you the ability to clear all slicers in a page. To learn more about Power BI; read Power BI book from Rookie to Rock Star.

Sample Report Page

Here is a sample Power BI report page with a number of slicers:

Screenshot below shows a selected state of items;

If you want to clear every slicer; usually, there is a clear button on the slicer header. Or you can even enable Select All in the sclier format options. However, there is no Clear All for all the scliers in the page.

Solution: Bookmarks and Buttons

Solution is to use bookmarks. Here are steps:

Step 1: Open Bookmarks pane;

Step 2: Use the clear button on the header of every slicer. Do this for all slicers.

Step 3: Create a bookmark of the page, when none of slicers are selected.

Step 4: Create a Button for user interation; This button would be clear all button. You can even use Images with logos if you want to.

You can then configure the button to show a different text, with some formattings

Step 5: Bind the button to bookmark

Now that you have the clear all button, the last step is to set the Action property of that to bookmark, and select the “clear all slicers” bookmark for it.

Testing the solution

To test the solution, use Ctrl+Click on the desktop, or just click on it in the website;

Summary

Using buttons and bookmarks for clearing all slicers is only one of the multiple creative ways you can use bookmarks. I will write more about other usages of buttons and bookmarks together. Do you have some use cases yourself; don’t hesistae to write in the comment below.

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
FacebooktwitterlinkedinrssyoutubeFacebooktwitterlinkedinrssyoutube
Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for nine continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.

34 thoughts on “Clear All Slicers in Power BI; A Bookmark Story

  • Thank you for this detailed explanation. It is definately very useful.
    Does it work for the mobile view of reports as well?

  • Hi, would this work for selections made on visualisations. One thing I am struggling with, coming from a Qlik background, is being easily able to see what selections / filters I’ve made. In Power BI, it can be a bit confusing / misleading to know what an end user has selected

    • Hi Carl.
      Not sure if I understand your question exactly. If you want to select some items in the slicer and then create a bookmark from that selection, yes, it is working that way.
      otherwise; please elaborate more. Thanks
      Reza

  • What if you don’t want the slicers cleared when using bookmarks? I would like the slicers to stay as they were. Is there an option for this?

  • Hello, I build A clear filter like you write. It works on one page, when I want to use it on another pages, that doesnt work. The result is, I come back to the first page. How can I solve this? Thanks a lot!

    • Bookmarks are tied to a PAGE. It means only that page will be affected not others. If you want that to change also other pages, you have to combine this feature with the ability to SYNC slicers.
      when you sync slicers over multiple pages, change in one page, will affect others too.

  • Hi Reza –
    I have a report level filter which is applied in my report across pages. Suppose, if I want to create a Reset button (using Bookmark) for a page which should reset every slicer present in the same page but should not reset the REPORT LEVEL FILTER. How can I achieve this? If I am unchecking the “DATA” option, it is carrying forward all the filters (including the Report level filter), and If I am checking the “DATA” option, it is resetting all the filters (including the Report level filter).
    Really hoping for a solution here.

  • Hey Reza,

    I have created a very simple test case where I have a slicer based on a table, with the search option enabled- click the ellipse (…) and select the little magnifier glass.
    I created a bookmark called Clear Filter with nothing selected in the slicer.
    Created a button called Filter Reset and link the action to the bookmark.
    When I select entries in the slicer, then use the Filter Reset button, everything works and the selections disappear
    But when I enter a value in the search line of the slicer, and click the Filter Reset button, the search text in the slicer does not get cleared, nor does entries in the slicer get updated to the original list.

    Is this a known limitation with bookmarks and slicers using the Search option? Or am I doing something wrong

    Paul

  • Hi Reza,
    I want to show/hide visuals but keep filters as i have set them – can that be done with selection, bookmarks and buttons? Often i just want to hide one visual and show another, but without having the bookmark to restore the filters back to its original state and at the same time i dont want to reset all filters just to prevent that.

    • You can.
      When you create the bookmark, with right-click on it in the bookmark tab, you can choose does it contains data, visual, or other stuff. you can uncheck the data for the bookmark for your scenario
      Cheers
      Reza

  • Hello,
    I tried using the 3 visuals, column, bar and Line Chart. using 3 buttons to show each one of them and hiding other 2. but it didn’t work in Power BI Desktop.

  • Hi Reza,
    Is it possible to create a clear filter except on one visual ?
    I have a slicer data (as Relative) and each time I use clear filter button on the page report, all visuals are cleared (great !!!) but slicer data becomes “Between”.
    Thanks for your help !

  • Yea I am also trying this and it is not working. I created the bookmark, renamed etc. What do you mean by CTRL + click on the Power BI desktop? I have tried everything and it is not working. I have 4 filters that I want to clear all for.

    • I mean holding the CTRL key in your keyboard, and then clicking on the button.
      or publishing the power bi file into the service, and then testing it with normal click.
      if it doesn’t work, send me you PBIX file and I’ll see what is wrong

      Cheers
      Reza

Leave a Reply

Your email address will not be published. Required fields are marked *