Power BI Exercises

Sunday pop merch

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

The request, from Oskar Lind, Merch Manager, Pinewave: "Pop fans on Sunday buy a lot of merch. Which pop acts sold what on Sunday? Give me slicers so I can check other days too." A table of merch sales by artist, with a Day slicer on Sunday and a Genre slicer on Pop.

Several slicers on a page are combined with AND: a show has to match the selection in every slicer.

Task: Create a Table with Artist[Artist] and the Sum of Merch Sales.

Task: Add a slicer on Performances[Day] and select Sunday.

Task: Click the table (so the first slicer is no longer selected), then add a second slicer on Artist[Genre] and select Pop.

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