Storytelling with Power BI 2/7: Be dynamic

Time for the second of seven blogs, as part of my blog series regarding Storytelling with Power BI. During this blog series, I will elaborate on seven topic which can be used to apply storytelling features to your own reports.

Be dynamic can be interpenetrated in a lot of different ways. During my webinar I used an example where the top 10, top 20 or all countries in a ranking where showed. This was all based on a report which is published to the web and shown below.


Change the (filter) context

As said, being dynamic is a broad concept. Lets use the above shown example. As a report author, we can define that the end-user should be looking at an top 10 ranking of countries (right side of the report). Since the difference between number 9 and 10 in the ranking is so small, you might want to know what the difference is to number 11. Now, we can’t see that. We need to change the filter context to see the rest of the ranking.

In this example the report author added three buttons for the end-user to interact with the report in choose the filtercontext them selves. This is all done by bookmarks. So let’s walk through the steps you have to take to create something similar.

  1. First create a basic bar chart where you add a measure and a dimension. In my example I used the Strava Friend Name as dimension and # kudos received as measure.
  2. Open both the filter pane and the bookmarks pane.
  3. Under visual level filters, go to your dimension and choose Top N as filter type.
  4. Fill the Top N field, as an example we’re going to create a top 10.
  5. Drag the same measure as you used before in the By value field.
  6. Click apply filter.
  7. Now create the first bookmark and name it Top 10.
  8. Change the number which you filled in as Top N in step 4. In my example I changed it to 20.
  9. Click apply again.
  10. Create another bookmark and rename this one to Top 20.
  11. Go to the properties of the bookmarks, and change both of them to only Data. 
  12. Add two buttons to your canvas. Find the buttons in the top ribbon under home.
  13. Assign actions to the buttons. One to the bookmark Top 10, and assign the other button to bookmark top 20.


This is just one example identical to the one in the demo by changing the filter context. Of course you can use an identical purpose for a lot of other interactions as well. For example changing the sort order or drilling to another level or granularity.

2 thoughts on “Storytelling with Power BI 2/7: Be dynamic

  1. Pingback: Using Bookmarks for Power BI Filters – Curated SQL

  2. Pingback: Webinar recap & blog series: Storytelling & interactive reporting with Power BI – Data – Marc

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s