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
- Previous: Highlight instead of filter
- Next: Navigation buttons both ways
- Report Pages & Interactivity: Tooltip page and a synced slicer
- Report Pages & Interactivity: A hidden page for drafts
- Report Pages & Interactivity: A custom tooltip page
- Report Pages & Interactivity: Add the way back
- All Power BI practice exercises