Power BI Exercises

Drill through to a genre

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: "From any chart, I want to jump straight to the film list for one genre." A drillthrough on Genre to the Films page.

A drillthrough page shows the details of whatever the reader right-clicks. Put Film[Genre] in the Films page’s Drill through well, and any visual with Genre can jump there, filtered.

Task: Go to the Films page.

Task: With no visual selected, add Genre to Drill through.

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