Power BI Exercises

The three quietest acts

Filters & Slicers · Intermediate · 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: "Which three acts drew the smallest crowds over the weekend? I want to rethink their slots, not drop them." A bar chart of the bottom 3 artists by attendance.

Top N also works the other way round. Switch Top to Bottom to keep the N items with the lowest value, which is handy for finding what needs attention.

Task: Create a Stacked bar chart of Performances[Attendance] by Artist[Artist].

Task: In Filters on this visual, open Artist, set Filter type: Top N, choose Bottom 3 by Sum of Attendance and apply.

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.

Keep practicing