Learning bookmarks in Power BI Desktop
Part three of a five-part series of blogs

You can use bookmarks to take your reports to the next level - they take a while to get used to, as this blog shows, but they're worth the hassle!

  1. Bookmarks - What are they, and why should you care?
  2. Creating, naming and connecting to bookmarks
  3. Using the DATA option of Bookmarks (this blog)
  4. Using the Display option of Bookmarks
  5. Using the ALL/SELECTED option of bookmarks

Posted by Sam Lowrie on 14 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 the data option of Bookmarks

Bookmarks can be tricky!  To make things easier this blog only covers the Data option. See later in this series for pages on the Display and All/Selected Visuals options:

Data Bookmarks Power Bi Desktop

Most of the time you will have all three ticked.  Let's look at what they do!

Data concerns filters, cross highlighting, drill-downs and sorting. To demonstrate this I have a pre-made page with some visuals on it:

Table Chart Slicer Bookmark

The page has a little bit of all of the features included in the Data option of bookmarks.

 

Now I will create two bookmarks of the same page (but one with the data option on and the other with it off to see the difference):

Data bookmarks whoop Data bookmarks whoop
Data option on. Data option off.

 

 The newly created bookmarks look like this:

Table Chart Slicer Bookmark Table Chart Slicer Bookmark
Bookmark with Data option ticked. Bookmark with Data option not ticked.

With the Data option on all of the related settings are saved at the point of creation (or update). Including the current drilldown, cross highlighting, sort order and filtering. Currently they look the same, but let's try navigating to them using a bookmark link:

Data Image Charts Report Power Bi Desktop

While the bookmark with Data ticked remain them same, the other reverted to its original unfiltered state.

Why would you ever have Data off? One answer is when you want to stay on the same page and maintain any filters already in place, but change the images on the page. With Data on, the bookmark would revert to the filter settings set when it was created. 

This blog has 0 threads Add post