Using bookmarks to clear slicers

First up, a button to clear all the filters on a page. Consider this over-filtered report:

Too many filters!

There are some serious problems with this report. Too many filters can let your users get lost, so let's throw them a life line:

The saviour!  The cleaner-away of filters has arrived. A text box saying Clear filters would work too - it would just be a bit boring.

What I want to do is create a bookmark that has all the filters set to their default. This may be:

• empty for the slicers;
• nothing clicked for the chart; and
• everything checked for the treemap.

Begin by removing all of the report's filters:

Clear slicers using the little rubber icon.

Most visuals can be cleared by clicking a highlighted column/cell.

Once you have the entire page set to the defaults you want, add the bookmark, calling it something like Clear filters:

Data will save all the settings regarding slicers, cross highlighting, drill down and sorting.

Display won't have any impact for this example, regardless of whether it's ticked or not.

I want all my visuals to be included in the reset.

Connect this bookmark to the image or button that you have created and prepare to wash the slate clean:

To make things easier I renamed my icon to Filter image. Use the Title option to do this.

Now sit back and wait for the appreciative crowds of report users to shower you with with praise.

Ha! They probably won't even notice ...