Introduction
Bookmarks in Power BI can be so tricky sometimes but they’re so satisfying when everything lines up the way you want it to.
This weeks challenge by Vivien Lee looks simple at first, it’s only one chart, one table, and a few buttons. But click on the info button in the corner and the page turns into instructions that guide the user on how the dashboard works.
This is a small use-case but the same thing can be applied to bigger and more complex reports where a user might not immediately know what a chart is showing, or what a filter does, or even where to start.
A solution blog and file can be found ⬇️
Dataset
Data for this challenge can be obtained from GitHub.
https://github.com/Imba456/Workout-Wednesday-for-Power-BI/blob/main/datasets/Motorsports%20Mock%20Data.xlsx
Requirements
Table:
- Create a measure for the Fastest Lap per Race.
- Create the table and use the measure you just made to highlight the fastest lap for each race.
- Add a slicer for Race.
Bump Charts:
- Create two bump charts using Team Standings and Driver Standings.
- Line them up so they overlap.
- Create two bookmarks – one shows the Team Standings chart and hides the Driver Standings chart and the other bookmark does the inverse. Make sure you turn on selected visuals and select the correct layers when you create or update each bookmark.
- For the design, I used 3 pill shapes. One longer grey one, and two smaller red ones that go under each bookmark and show/hide depending on which bookmark is selected.
Information Button:
- Insert two information buttons.
- Create the instructions view using arrows and text to explain the slicer, bookmarks, and table. You can also overlay the whole page with a shape to grey everything out and put it behind the slicer/bookmarks to highlight them.
- Create two bookmarks “Info button on” where everything you just created is shown, and “Info button off” where this is all hidden.
- Set the actions for the two info buttons.
Bonus Challenge:
The bonus challenge is to create the toggle to switch from the Overall view to the Focused view. This involves more bookmarks!
Share
After you finish your workout, share on social media using the hashtags #WOW2026 and #PowerBI.
On Bluesky, tag @mmarie.bsky.social, @shan-gsd.bsky.social, and @merrykerry.bsky.social.
On LinkedIn, tag @VivienLee and @RobbinVernooij