Making Reports Interactive

You built one sales report. Then three people opened it in the same meeting. The regional VP wants to see the West. The finance lead only cares about last quarter. A product manager wants the outdoor line and nothing else. Three people, three questions, one report on the screen. You could go build three separate reports. Or you could let each person answer their own question by clicking.

That second option is what this chapter is about. Interactivity turns a static picture into a tool people can explore. Done well, you build once and serve many. Done badly, your readers get lost, filter themselves into an empty chart, and give up. The difference is design, and design is a skill you can learn.

Why this matters

Most business reports fail in the same quiet way. Someone builds a beautiful dashboard, and then the emails start: “Can you send me just the Northeast?” “What does this look like for March?” “Can you break this down by product?” Every question becomes another version of the file, another export, another afternoon gone.

An interactive report answers those questions on its own. The reader clicks a region and the whole page follows. They pick a month and every chart updates. You stop being the middle person who re-runs the report all day, and your readers get answers the moment they have questions.

A quick vocabulary check first. A visual is any single element on the report: a chart, a table, a map, or a number card. The canvas is the report page you arrange those visuals on. A field is one column of your data, such as Region, Month, or Sales.

The click that filters everything

Here is the most important thing to understand, because it is already happening whether you planned it or not. By default, when a reader selects a data point in one visual, every other visual on the page reacts.

Say your page has a bar chart of sales by region and a line chart of sales over time. A reader clicks the “West” bar. The line chart instantly redraws to show only the West. Power BI calls this cross-filtering: the click acts like a filter on the rest of the page.

Some visuals respond a little differently. A column or bar chart will dim the parts that do not match and keep the matching part bright, which is called cross-highlighting. Cross-filtering removes what does not apply; cross-highlighting keeps everything visible and fades what does not.

To undo it, the reader clicks the same data point again, or clicks any empty space inside that visual. This one behavior is the foundation of every interactive report: a reader can slice your whole page by clicking a bar, and no one has to teach them how.

Slicers: filter buttons your reader can see

Cross-filtering is powerful, but it is hidden. A new reader does not know they can click a bar. A slicer fixes that. A slicer is an on-canvas control, a visible box of choices, that filters the other visuals on the page and puts your most common filter right in front of the reader.

Power BI offers several slicer styles. The standard Slicer visual can appear as a vertical list of checkboxes, a set of tiles, a dropdown, or a date picker for choosing a date range. There is also a Button slicer that shows choices as clickable buttons, and a List slicer. Some of these styles are still marked as preview, meaning Microsoft is still finishing them, so check what your version offers.

By default a slicer lets a reader pick several values at once. You can also set it to single-select, so choosing one option clears the last. Single-select is the right call when picking two regions at the same time would confuse the numbers.

Try It Add a Region slicer to a report.

Open your report in Power BI Desktop, or open it in Editing view in the Power BI service.

In the Visualizations pane, select the Slicer icon. An empty slicer box appears on the canvas.

From the Data pane, drag a field such as Region onto that box. It fills with your region names.

Click a region. Watch the other visuals on the page filter to match. Hold Ctrl (or Cmd on a Mac) and click a second region to add it.

To force one choice at a time, select the slicer, open the Format pane (the paintbrush icon), find the Slicer settings, and turn on Single select.

To clear the slicer, hover over it and click the eraser icon.

What did you notice about how fast the page responded, and would a first-time reader know that clicking a bar does the same thing?

The Filters pane and its levels

Slicers live on the canvas for everyone to see. The Filters pane is a separate strip along the right side of the report, where you set filters that always apply, whether or not the reader touches anything. A filter you set here is saved with the report.

The Filters pane works at three levels, and knowing which level you are using is half the battle.

Report level   ->  applies to EVERY page in the report
   Page level  ->  applies to every visual on THIS page
      Visual   ->  applies to ONE selected visual only

A visual filter touches a single chart. Select the chart, and its fields already appear under “Filters on this visual.” A page filter applies to everything on the current page, useful for a page that should only ever show, say, the current fiscal year. A report filter applies to all pages at once, the place for a company-wide rule like “exclude cancelled orders.”

To set one, drag a field from the Data pane into the matching area of the Filters pane. You can also hide a filter from readers, or lock it so they cannot change it. There is a fourth type, the drillthrough filter, and it powers the next feature.

Drill-down: from the big picture to the detail

Some fields have natural levels stacked inside them. A date is a Year, then a Quarter, then a Month. A product catalog is a Category, then a Subcategory, then a Product. A stack of levels like this is called a hierarchy.

When a visual is built on a hierarchy, Power BI can show one level at a time and let the reader dig deeper. This is drill-down. A column chart might start at the year level. The reader drills into 2026 and the chart redraws to show its four quarters, then into Q2 to see April, May, and June, never leaving the page.

You control this with four small drill icons that sit at the top or bottom corner of the visual:

Drill up moves back to a higher level. It stays dimmed until you have drilled down at least once.
Click to turn on drill down switches on drill mode, so a click digs into one column instead of cross-filtering the page.
Go to the next level moves the whole chart down one level at once.
Expand all down one level keeps the current level and adds the next one underneath it, so you see quarters and their months together.

One thing to watch: by default, drilling one visual does not change the others on the page. A designer can turn that on, but out of the box, drill-down is a private exploration inside one chart.

Drill-through: jump to a page built for one thing

Drill-down digs into levels inside one visual. Drill-through does something different. It carries the reader to a whole separate page that is built to show the detail behind one item, already filtered to that item.

Picture a summary page of sales by customer. A reader right-clicks the bar for “Acme Corp” and chooses to drill through. Power BI opens your Customer Detail page showing only Acme: their order history, their contact card, their trend line. One page serves every customer, because it always shows whoever the reader arrived with.

Try It Build a drill-through detail page.

At the bottom of the canvas, select the + icon to add a new page. Right-click its tab, choose Rename Page, and call it something like Customer detail.

With that page open, go to the Visualizations pane and scroll to the Drillthrough section. Expand it if it is collapsed.

From the Data pane, drag the field you want to drill by, such as Customer, into the well labeled Add drillthrough fields here.

Power BI automatically adds a Back button to the page so readers can return.

Add a couple of visuals to this page: a card showing the customer name, and a table of their orders. They will show only the customer the reader drills in with.

Return to your summary page. Right-click a customer in a chart or table, choose Drill through, then pick Customer detail.

Try it with two different customers. Notice that you built the page once and it correctly reshapes for each one.

Bookmarks: save a view, build a button

A bookmark takes a snapshot of a report page exactly as it looks right now. It remembers the current page, the filters and slicers you set, which slicer values are chosen, any cross-highlighting, the sort order, and where you have drilled to. Later, one click returns to that exact view.

The everyday uses are simple. Save a “Reset” bookmark of the clean starting view, so a reader who has clicked themselves into a corner gets back with one button. Or save a handful of executive views (“By Region,” “By Month,” “Top Products”) and let readers flip between them.

To create one in Power BI Desktop, open the View tab and select Bookmarks to show the Bookmarks pane. Arrange the page the way you want it, then select Add. Rename it through the More options (…) menu next to its name.

To turn a bookmark into a button, go to the Insert ribbon, select Buttons, and add a Blank button. In the Format button pane, turn Action on, set the Type to Bookmark, and pick your bookmark. Now a click on that button jumps to the saved view, and a single “Reset filters” button built this way spares your readers a lot of confusion.

Custom tooltips: a small report on hover

A tooltip is the little box that appears when a reader hovers over a data point. Out of the box it shows the value under the cursor. You can make it far more useful, and it costs no screen space because it only appears on hover.

The quick version: select a visual, and in the Build visual pane drag an extra field into the Tooltip well. Now hovering a bar shows that bar’s sales plus, say, its profit margin and its order count.

The rich version is a report page tooltip, a miniature report that pops up on hover. You create a small page, set its canvas size to the Tooltip template, turn on the Tooltip toggle in Page Information, and add a few compact visuals. Assign it to a field, and hovering any matching data point shows that whole mini-page. A reader hovering over “West” could see a small trend line and two key numbers for the West, without a single click. Keep these pages small, because a large tooltip covers up the report underneath it.

Edit interactions: decide what filters what

By now you can see the risk. Every click cross-filters the whole page, and sometimes that is wrong. Maybe your page has a company-total card that should never change when someone clicks a region. Edit interactions lets you set, visual by visual, how one visual affects another.

Select a visual, then on the Format ribbon choose Edit interactions. Small icons appear on every other visual on the page. For each one you pick Filter, Highlight, or None. Choose None on that total card and it holds steady no matter what the reader clicks. In the Power BI service, the same control lives under a Visual interactions dropdown with an Edit interactions toggle.

This is the quiet difference between a report that feels smart and one that feels broken. Spend a few minutes clicking through your own page as a reader would, and turn off the interactions that do not make sense.

In business

A regional sales director opens Monday’s dashboard. Across the top sits a Region slicer and a date-range slicer. She clicks “Southeast” and picks the last full quarter. Every chart on the page reshapes to her question in under a second.

One number looks off, so she drills down in the revenue chart from quarter to month and spots that June sagged. She right-clicks the weakest account and drills through to a detail page with that customer’s full order history. Hovering over a product bar, a tooltip shows its margin trend without her leaving the page. Then she clicks the Reset button and hands the laptop to the finance lead, who asks a completely different question of the same report.

Nobody emailed you. Nobody waited for a new export. You built one report, and three executives served themselves three different answers.

Common pitfalls

Too many slicers. Five or six slicers stacked down the side looks thorough and leaves readers frozen. Keep them to the two or three filters people actually ask for, and let cross-filtering handle the rest.

Confusing cross-filtering. When a reader clicks a bar and a chart they did not expect goes blank, the report feels broken even though it is working as designed. Walk your own page, watch what each click does, and use Edit interactions to set anything surprising to None.

Drill paths that dead-end. A reader drills down three levels and then cannot tell how to get back, or drills through to a detail page with no Back button and feels trapped. Always confirm the drill-up icon works, keep the automatic Back button on drill-through pages, and give readers a Reset bookmark button so there is always a way home.

Hidden interactivity. If the only way to filter is to know you can click a bar, most readers never will. Make your key filters visible with slicers, and label your buttons in plain words like “Reset filters” so nothing depends on a reader guessing.

Practice

Take a report you have already built, or the sample from an earlier chapter, and make it self-serve. Do these four things in order.

Add one slicer for the filter people ask for most, and set it to single-select if multiple choices would muddle the numbers.
Build one drill-through detail page for whatever item readers most want the story behind: a customer, a product, or a store.
Add a Reset bookmark of the clean starting view, and wire it to a button labeled “Reset filters.”
Run Edit interactions across the page and set anything that should hold steady, like a company-total card, to None.

Then hand it to a colleague who has never seen it and watch them use it without instructions. Every place they hesitate is a place to fix. Once the report serves people on its own, you are ready for Chapter 8, where you publish it and share it so those readers can actually reach it.

Part of the Power BI track. Developed with AI assistance and reviewed by a human editor. Power BI changes often; menu names, features, and prices may have shifted since the “checked on” dates in this chapter. Verify anything critical against Microsoft’s official documentation.