Business Data Analytics & Advanced Excel · Intermediate level

Intermediate level · Module 4: Designing Power BI Reports · Lesson 2 of 3

Interactivity

Let users explore with slicers, drill-through and tooltips without getting lost.

In this lesson you will

  • Sync slicers across pages
  • Add drill-through pages and report tooltips

Key concepts

synced slicersdrill-down and drill-throughtooltip pagesbookmarks

The lesson

Sync slicers so a branch chosen on one page applies on others. Keep the number of slicers small.

Drill-through lets users right-click a branch and open a detail page filtered to it. Report tooltips show extra detail when hovering.

Bookmarks can save views, such as 'this month' and 'year to date'. Test every interaction from a user's point of view.

Step by step

  1. Sync the branch slicer across pages.
  2. Create a branch drill-through page.
  3. Add a tooltip page.
  4. Test the interactions with a classmate.

Practice activity

Add interactivity to the reporting solution.

Expected result: Working synced slicers, drill-through and tooltips, tested by a user.

Check your understanding

  1. What does drill-through do?

    Show answer

    Opens a detail page filtered to the item selected.

  2. Why keep the number of slicers small?

    Show answer

    Too many slicers confuse users.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.