Power BI: bookmarks or pages ?

Create a page is easier than to create a bookmark but the best way to optimize a report, it is the combination of both, of course, depending of my data and the way to present it, I can have only pages and not using any bookmarks. Bookmarks have many advantages but there are 3 main inconvenients:

  • Create a button to link each bookmark
  • Good management of visuals to hide or unhide them
  • Save/update each bookmark for any modifications

In pages, I don’t have to think about those points although I still can use bookmarks. Let´s take an example, I want to create a report showing incident and problem performances:

  • Option 1, create 2 pages, one for incident and one for problem. In this scenario, I just put my visuals like charts, tables, maps, etc. and I have nothing more to do
    NOTE: remember, I still can use bookmarks in this scenario
  • Option 2, create 1 page with 2 bookmarks, one for incident and one for problem. In this scenario, I have to create 2 buttons for each bookmark:
    • For incident, hide all problem visuals and importantly, not forget to save/update the “incident bookmark”
    • For problem, hide all incident visuals and importantly, not forget to save/update the “problem bookmark”

Take note that bookmarks can be used for only 1 or more specific visuals. For instance, in “incident” page, I have 3 maps and by default, I want my audience to see only 2 and then they click on a button, the last one will appear. Alternatively, there is another way to do this trick using formula (read Power BI: hide visual and change background color based on selection) but for multiple visuals, the best way to do it is with bookmarks.

Let me show you, pictures are more speaking than words in some situations. For the option 1, I just create 2 pages and put my visuals:

power bi

For the option 2, I will put all visuals in one single page:

power bi

So if I want my audience to see them, I don’t need to use bookmark but imagine that I want them to see only the “incident” (the 2 top) visuals by default and to show the “problem” (the 2 down) visuals only after doing an action, in this case, by clicking on a button.

First, I will make appear the “bookmark” and “selection” panels by clicking on “view”:

power bi power bi

On the “bookmarks” panel, I will click 2 times on “add” (left picture) then I will rename the first one as “incident” and the second one as “problem” by clicking on the “3 dots -> rename” (right picture):

power bi power bi

In the “selection” panel, I will hide the “problem” visuals by clicking on the “eye”:

power bi

NOTE:

  • Bookmarks and visuals can be moved up or down, click on it and move it
  • Bookmarks and visuals can be grouped, select some of them then click on the “3 dots” to see the “group” option

In the “bookmarks” panel, for “incident”, click on the “3 dots -> update”:

power bi

NOTE: if I forget to do that, I will have to repeat the process again. Remember what I said before, for any modifications, I have to click on “update” to save what I did

In the “bookmarks” panel, click first on “problem” to show all visuals then hide the “incident” visuals then click on “udpdate”:

power bi

Now in the “bookmarks” panel, if I click on “incident”, I will see only its visuals and if I click on “problem”, I will display only its. As I said above, by default, my audience will see “incident”, for them, to see “problem”, I have to create 2 buttons by clicking on “insert -> shapes”:

power bi power bi

For the first one, in the “format shape” panel, turn on “text” inside “style” then in the “text” field, put “incident” and turn on “action” then on “type”, select “bookmark” and in “bookmark” field, select “incident”. Do the same thing for the second one by naming it “problem” then linked to its bookmark:

power bi power bi power bi power bi
power bi

Now if I move my mouse in the “incident” button, I will see this message:

power bi

NOTE: once published the report in Power BI Service, only 1 click is enough, the “CTRL” is only in Power BI Desktop

By doing so, I will make appear the “incident” visuals and vise versa for “problem”. Now, let’s go further, I want to hide the “incident” button for the “incident” bookmark so I just have to select it, click on the “eye” in the “selection” panel then click on “update” for the “incident” bookmark:

power bi

Doing the same process for “problem”:

power bi

Important things to know about bookmark:

  • Bookmarks can be used in multiple pages, of course, the same bookmark can’t be used for different pages
  • Multiple bookmarks in one single page are more difficult to manage

Explanation of the other options of bookmark:

  • By keeping the “data” selected, cross filtering between visuals, visuals sort order, visuals drill downs and filter/slicer selections will be saved in the bookmark
  • By keeping the “display” selected, all hidden visuals will be kept hidden
  • By keeping the “current page” selected, you will always be redirected to the page where the bookmark has been created
  • For the last 2 options, you will have to select one of them:
    • Selecting “all visuals”, you will save the configuration of all the visuals as they are. For instance, if I have 1 slicer called “type” with 2 options (open and close) and I select “open” then “update” my bookmark, it will keep my selection as default
      power bi
    • Selecting “selected visuals”, you will save only the configuration of the selected visuals as they are. For instance, if I have 2 slicers called “type” and “priority” and I select “type” then “update” my bookmark, by switching between bookmarks, “type” will always reset with my default selection meanwhile “priority” will not
      power bi

Interesting Topics