Launch Deal · 50% off 1st month ·

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:

  1. On the target page, add a field to Drill through in the Visualizations pane (for example Product Name).
  2. Power BI adds a Back button to the page automatically.
  3. Keep all filters passes every filter from the source visual's context, not only the drillthrough field.
  4. 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).
  5. 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.

See plans

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.