Power BI Exercises

Saturday’s merch champions

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: "Saturday was our big merch day. Which three acts sold the most merch that day? I need to reorder their T-shirts." A column chart of the top 3 artists by merch sales, Saturday only.

A Top N filter is worked out inside the other filters. Add a Day filter and the Top 3 is the top 3 of that day, not of the whole festival.

Task: Create a Stacked column chart of Performances[Merch Sales] by Artist[Artist].

Task: Set the Artist filter to Top 3 by Sum of Merch Sales.

Task: Add Performances[Day] to Filters on this visual and keep only Saturday.

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