Power BI Exercises

Highlight instead of filter

Report Pages & Interactivity · Intermediate · Chapter 3 of 10. Multi-page reports: edit interactions, drillthrough, sync slicers, bookmarks, buttons and tooltip pages.

The request, from Maya Lindqvist, Marketing Lead, Lumen Cinemas: "When I click a cinema, the film chart shrinks to a few bars. I'd rather see all films with that cinema highlighted." Revenue by Cinema set to highlight Tickets by Film.

When you click a column, the other visuals react: by default they filter. Highlight keeps every bar and shades the part that belongs to your selection, so readers keep the full picture.

Task: Select Revenue by Cinema.

Task: Turn on Edit interactions and set Tickets by Film to Highlight.

Practice data: Lumen Cinemas, a fictional cinema chain with films, screenings and ticket sales. The model has the Screenings, Film and Cinema tables.

How it works: the exercise opens a practice copy of the Power BI report editor in your browser. Do the task, press Check, and your result is compared with the expected answer in seconds. Hints are there if you get stuck.

Keep practicing