BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
This blog gives some suggestions for how you might use the new bookmarks feature in Power BI Desktop.
- Some interesting ideas for uses of bookmarks
- Using bookmarks to clear slicers (this blog)
- Creating the effect of a tabbed dialog box
- Expanding and collapsing menus using bookmarks
- 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:

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 ...
The animated GIF above shows a before-and-after screen shot of the report. You can see a list of all or our Power BI courses here.
- Some interesting ideas for uses of bookmarks
- Using bookmarks to clear slicers (this blog)
- Creating the effect of a tabbed dialog box
- Expanding and collapsing menus using bookmarks
- Providing buttons to move between pages