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.
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:
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.