In this tutorial, you will learn how to use bookmarks in Power BI to create interesting and useful reports. Bookmarks were introduced a few months ago and they can be very useful to capture key data and create powerful reports.
In this example, we will be creating a report with bookmarks that show the sales data for four individual countries. To start, let’s take a simple dataset containing Sales columns.
If you put the data in a table visual, you will see that the data represents sales in four countries: Canada, France, Germany and Mexico:
This report contains three visuals:
- Units by Year, Quarter, Month and Day
- Revenue by Year, Quarter, Month and Day, and
- A table visual showing unit sold and revenue by ProductID
To view the data by country, we will be adding a Slicer and Bookmark for every country.
Start by enabling the Bookmarks Pane. Go to the View tab and check the Bookmarks Pane box, where it will appear next to the Visualizations Pane.
You don’t need to see the Slicer in the actual report, so go ahead and remove the Slicer in appearance (not selection) by adding the Selection Pane and hiding the Slicer.
To link these images to their respective bookmarks, select the first image of the Canadian flag. Go to the Format Image Pane, set the Action button to On, select the Type: Bookmark and then select the Canada Bookmark.
The final piece of this report is the Back button, which will allow you to navigate back to the first page. To add a Back button, click Buttons and the Back icon in the dropdown. You can add it anywhere in your report.
Now, you can play around with the report by using Ctrl+Click to navigate back and forth to each bookmark and the initial page with the flag images.