Rock or indie
Filters & Slicers · Beginner · Chapter 2 of 10. Visual filters, Top N and slicers: show exactly the data the business asked for.
The request, from Nina Okafor, Head of Programming, Pinewave: "I'm booking the guitar line-up for next summer. Can I see every rock and indie act with their total attendance?" A table of attendance by artist, only Rock and Indie.
Inside one filter, the values you tick are combined with OR: a show is kept if its genre is the first one or the second one.
Task: Create a Table with Artist[Artist] and the Sum of Attendance.
Task: Add Artist[Genre] to Filters on this visual (from + Add a field…) and tick Rock and Indie.
Practice data: Pinewave Festival, a fictional music festival with tickets, stages, artists and merch. The model has the Performances, Artist and Stage 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.