Some suggestions for possible uses for bookmarks in Power BI Desktop
Part two of a five-part series of blogs

This blog gives some suggestions for how you might use the new bookmarks feature in Power BI Desktop.

  1. Some interesting ideas for uses of bookmarks
  2. Using bookmarks to clear slicers (this blog)
  3. Creating the effect of a tabbed dialog box
  4. Expanding and collapsing menus using bookmarks
  5. Providing buttons to move between pages

Posted by Sam Lowrie on 24 March 2018

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Using bookmarks to clear slicers

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

Bookmarks Spartans Filters Slicers

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:

Filter Slicer bookmark logo

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:

Slicer Filter Clear Bookmarks

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:

Bookmarks Filters Clear All

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:

Filter slicers clear hard reset

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.

Slicer Filter Bookmarks Tips and tricks

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

The animated GIF above shows a before-and-after screen shot of the report.

This blog has 0 threads Add post