3.6 — Visual Interactions, Drillthrough, Sync Slicers and Sorting
PL-300 Domain 3 · Skill 3.6
What You Need to Know
Interactions between visuals
Selecting a data point in one visual affects the others on the page. Select the source visual, then Format > Edit interactions. Each other visual shows icons:
| Interaction | Effect |
|---|---|
| Filter | Shows only the selected data |
| Highlight (default for many charts) | Shows the selected portion in full color and the rest dimmed |
| None | Not affected |
Slicers use Filter or None. Under File > Options > Report settings you can make cross-filter the default instead of cross-highlight. Ctrl+click selects several data points.
Drill down and drillthrough
- Drill down/up moves through a hierarchy within one visual (Year > Quarter > Month). Use the drill arrows or Expand to next level.
- Drillthrough opens another page, filtered to the item you right-clicked.
Setting up drillthrough:
- On the target page, add a field to Drill through in the Visualizations pane (for example Product Name).
- Power BI adds a Back button to the page automatically.
- Keep all filters passes every filter from the source visual's context, not only the drillthrough field.
- Cross-report drillthrough lets a target page in another report in the same workspace or app receive the drillthrough (turn it on in the target report's settings and on the field).
- A button with the Drill through action can trigger it: the button is disabled until the reader selects a valid data point, and its destination can be set by a measure.
Hide drillthrough pages so readers use them only in context.
Sync slicers
View > Sync slicers shows, for a selected slicer, every page with two checkboxes:
| Checkbox | Meaning |
|---|---|
| Sync | The selection applies to that page |
| Visible | The slicer appears on that page |
So a slicer can filter a page without being shown there (Sync on, Visible off). Advanced options put slicers in a group so different slicers on the same field stay in sync.
Sorting visuals
- Use More options (…) > Sort axis to choose the sort field and ascending or descending. Charts can sort by any field in the visual, including one in the tooltip well.
- In a table, click a column header; Shift+click adds a secondary sort.
- Sort categories in a non-alphabetical order (month names, sizes S/M/L) with Sort by column in the model (lesson 2.1).
Key Concept: Edit interactions controls how visuals on the same page affect each other. Drillthrough sends a reader to a detail page filtered to what they clicked. Sync slicers carry a slicer's selection to other pages, visible or not.
Exam Traps
- Using drill down when the requirement is a separate detail page (drillthrough)
- Forgetting Keep all filters when the detail page must keep the source page's slicer context
- Putting the same slicer on every page without syncing them
- Assuming Sync requires the slicer to be visible on the page
- Sorting month names with a DAX trick instead of Sort by column
Check your understanding
Practice Scenario
🔒 This practice scenario is part of Skillmarked Pro
The lessons stay free. Pro unlocks the other 22 PL-300 practice scenarios and the 50-question timed mock exam, plus everything for every other exam.
Launch Deal: first month €9.95, then €19.90/month. Enter code LAUNCH50 at checkout. Ends 1 December.
Cancel anytime. Or €199 a year, which saves 17%.
Not sure yet? Try 10 free mock exam questions.
Already Pro? Log in.
Sources
- Change how visuals interact in a report, Microsoft Learn
- Set up drillthrough in Power BI reports, Microsoft Learn
- Sync and use slicers on other pages, Microsoft Learn
- Change how a chart is sorted, Microsoft Learn