Friday and Saturday only
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: "Sunday tickets are a separate deal. For the Friday and Saturday crowd only, how full was each stage? Let me switch days myself." A column chart of attendance by stage, with a Day slicer on Friday and Saturday.
A slicer can keep several values at once: tick each one you want. In Power BI Desktop you can also hold Ctrl and click.
Task: Create a Stacked column chart of Performances[Attendance] by Stage[Stage].
Task: Add a Slicer on Performances[Day] and select Friday and 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.