Power BI Exercises

Everything except The Tent

Filters & Slicers · Beginner · Chapter 2 of 10. Visual filters, Top N and slicers: show exactly the data the business asked for.

The request, from Ray Calder, Festival Director, Pinewave: "The Tent is being rebuilt for next year, so leave it out. How many fans did each of the other stages pull in?" A column chart of attendance by stage, without The Tent.

New dataset! These exercises use the Pinewave Festival: three days, four stages and thirty acts. Performances has one row per show, with its Attendance and Merch Sales; Artist and Stage describe who played where. Basic filtering has no "not equal to". To leave one value out, tick every value you want to keep. The values you leave unticked are filtered out.

Task: Create a Stacked column chart of Performances[Attendance] by Stage[Stage].

Task: In Filters on this visual, open Stage and tick every stage except The Tent.

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