Data Visualization Workout 006 - Bookmarks & bookmark navigator

Workout 006 – Contractors profitability – bookmarks & bookmark navigator
Difficulty rating: 2.5 out of 5

Intro note
After a few tough workouts that included variety of different dax techniques, this time we are going to put less focus on that matter and address a quite relevant UI/UX aspect, which in PBI is heavily related with bookmarks functionalities.

This technique is fairly simple yet very powerful and I strongly believe that it’s going to save hundreds of ‘clicks’ and make even complex visualization switches quite comfortable - which also helps us to expand our creativity (if it’s a simple process, then we know we can implement them more often in our projects).

During the workout, I kindly ask to focus on a very specific bookmark functionalities, which are: turning off the “Data” option and turning “Selected visuals” on (when updating the bookmark), creating bookmarks groups (similar as groping the objects but this time we are going to group bookmarks) and incorporating bookmark navigator (to further saves a lot of clicks comparing to button creation in a standard way). Whenever sth will need further explanation or guidance - please, feel free to ask on the forum.

Three included visualization (column chart / scatter chart / table) include only basic formatting options and does not include any more complex PBI functionalities. This are basic visualizations that allows us to create user experience though bookmark implementation.

This workout combines various visualization techniques. The most important part of the workout is practice - entries does not have to include every element or functionality to be still considered as great . Please pay attention to the list of functionalities (provided in the screenshoot and in published-to-web report), which includes ‘basic’ elements (1st-7th point), and supplemental (8th point).

Following workout bases on exact same data source as provided in workout 002 and workout 005 - if you already participated in one of this two workouts - please feel free to reuse your already transformed datasource / model / measures etc.

**Following workout does not require to use each column. Nevertheless, please feel free to use any columns and any data which is valuable from your perspective. Feel free to use your entries as a part of your project portfolio, if it’s instrumental in realizing your goals.


In this workout, using the supplied dataset and reviewing the provided interactive report (link below) we are going to replicate the following set of vizualizations (left section in a report screenshot), including the column charts, scatter chart, table, slicer pane and bookmark navigation experience. Also, please feel free to add any extra visual if you would like to (provided that core visualizations are included in the first place).

006 - Workout - Contractor profitability (bookmarks).xlsx (110.9 KB)

Core actions (practice) :

    • Making basic calculation (gross margin)
    • Implementing basic formatting options in column & scatter chart and in a table
    • Using object grouping
    • Using bookmars and bookmark groups
    • Using bookmark navigator


Please load the supplied data (xls file) into a Power BI file, replicate visualizations (considerating list of points in the introductory report screenshot and the general design and functionality provided through interactive published-to-web report), and reply to this post including the screenshot (or a gif) of your solution along with the pbix file (please, include name or EDNA forum nick in the pbix name).


This workout is released on Tuesday April 05, 2023, and the author’s solution will be posted on Monday/Tuesday May 8-9, 2023.

Additional materials

Link to the interactive dashboard:

Sample view of grouped bookmarks:

Sample view of grouped objects:

Sample view of used bookmark options:

Sample presentation of following workout:

Have a great fun!

Best regards!


Let’s go again

1 Like

Absolutely, 100%!

1 Like

I am starting this one early so I can finish :boom:


Here’s my submission for this exercise. I think Gustaw was lenient with us on this one


Hi @windler.nikki nice job, I have a observation on your report. You have place the Slicer Off and Slicer On option in different element, however as per the sample given by @Gustaw it was on the first element where all the column charts and other visuals are available.


Hi, thank you @Bq1BQfLi I have already made the update. :slight_smile:


I would say, I don’t think the purpose of these exercises “have to be” exact copies of what Gustaw sets us, although that is what I’ve been trying to mostly do. It’s about learning/discovering the concepts that are present. So, I liked how the Slicers OFF Slicers ON elements were housed in your control panel on the right, looked really good (as do all your submissions ;))


Oh, thank you very much @DavieJoe for those kind words. I feel the same way as you do. I’m always happy to learn something new. :slight_smile:


Here’s my effort, took me a little while to get my Selected Visuals feature working properly. I tended to avoid it previously as I never got my head around it, until now (I think :rofl:)


Data Visualization Workout 006 – Profitability - Bookmarks & Bookmark Navigator.pbix (186.4 KB)


He’s back awesome work @DavieJoe


Ha, thanks. Now got to go back and finish challenge 005 this week.


I really do appreciate the kind words! :wink:


Thanks @Gustaw for another great workout. I got stuck for a while on Selected visuals but so easy when you know.

Workout #6 Bookmark & Navigator Kim Cook.pbix (243.7 KB)



Here is my submission -I had to get my head around selected visuals and the DAX formula to get the table total for contractors. Thanks, @Gustaw for the great workout

Report Link

PBIX Report
EDNA Visuals 006.pbix (216.3 KB)



Looks great @KimC

I had a mildly infuriating hour or so getting to grips with Selected Visuals. :face_with_symbols_over_mouth::face_with_symbols_over_mouth:


Same :sweat_smile: :sweat_smile: :sweat_smile:


I did the same !


first time on bookmark. Funny but not so easy…
At the end (I think) I understood the Select Visual option and so I could create all the buttons and bookmarks.
I also created a button to quick filter top 5 Contractors in Table tab.
Please find attched my pbix.
What I am not able to do is to Disable/enable the Slicers in all the 3 pages at the same time.
I can only Disable/Enable them in the current page.
Would you please give me a suggestion ?
Thanks and ciao !

Workout 006 - bookmarks - Roberto Ravani.pbix (470.1 KB)


Hi Roberto,
everything you have done works looks great however try to have one sheet only instead of 3 (similar to what you did with show Top % customer & show ALL customers) and use your bookmarks.