Module 7: Visuals and report design · Lesson 7.2 · about 14 min
Slicers, cross-filtering and interactions
Slicers let people filter the report; visuals filter each other when clicked. Control both with sync slicers and Edit interactions, and write titles that say what is selected.
Module 7 · about 14 minutes · read first: 5.1. You’ll be able to set up slicers and interactions so the report behaves the way readers expect.
1. Why this matters
Interactivity is what makes Power BI more than a printed report. Badly set up, it confuses people (“why did that chart go blank?”). Well set up, managers answer their own questions.
2. Slicers
- Slicer visual: pick a field (Store[Region], Date[Year]). Styles: list, dropdown, tiles, between (for numbers and dates), relative date (“last 3 months”).
- Single select for things like Year when combining years makes no sense.
- Sync slicers (View > Sync slicers) shares a selection across pages.
- Filters pane for filters readers shouldn’t change (hide or lock them) and for page- or report-wide filters.
Every selection becomes part of each visual’s filter context (Lesson 5.1).
3. Cross-filtering and highlighting
Click a bar and other visuals on the page react: by default they highlight (show the selected part darker) or filter. Select a visual, then Format > Edit interactions: icons appear on the other visuals to choose Filter, Highlight or None. Typical choices: the card row should filter; a “total company” chart should ignore clicks (None).
4. Say what is selected
Readers forget what they clicked. Put the selection in titles with a measure (visual Format > Title > fx > choose the measure):
Write a dynamic title: Title = "Sales for " followed by the selected region, or "all regions" when none or several are selected. Use SELECTEDVALUE(Store[Region], "all regions"). Try Split by Region, then nothing.
Press Run to see the result.
Title = "Sales for " & SELECTEDVALUE(Store[Region], "all regions") Principle
Principle: every interaction is just another filter in the filter context. A slicer adds filters to all visuals it’s connected to; a click adds a filter to visuals set to Filter; Edit interactions decides which visuals receive which filters.
Try it: a card shows Total Sales with Region = West sliced. Someone clicks the Home bar in a chart set to filter. What does the card show? (West sales of Home products.)
5. Worked example
The store manager’s report. A Store slicer (single select, synced on all pages), a Year slicer (single select), and a relative date slicer “last 13 weeks” on the trend page only. The “Chain total” card is set to None for the Store slicer interaction, so managers always see their store next to the chain. Titles read “Sales for Rideau, 2025”.
6. Practice
- Write a title measure that lists all selected stores, separated by commas. (Hint: CONCATENATEX(VALUES(Store[Store]), Store[Store], ”, ”).)
- Which slicer style suits dates for “last 30 days”?
- A chart goes blank when someone selects a store that sells no Outdoor goods. Is that a bug?
Answers
Stores = CONCATENATEX(VALUES(Store[Store]), Store[Store], ", ").- A relative date slicer.
- No: the filter context has no rows for that combination. Add a message measure such as “No sales for this selection” with IF(ISBLANK(…)).
Check yourself
Your ticks stay in this browser. Save them as a file on the course home.
Updated 2026-11-22. Northbay Goods is a made-up shop and its numbers are generated. Power BI changes every month: menu names can move, so check Microsoft Learn if a button is not where the lesson says. The practice editor runs in your browser; nothing you type is sent anywhere.