Static charts answer the question you thought to ask — interactive reports answer the questions users think of on the spot. This lesson walks you through building custom tooltip pages and drill-through navigation in Power BI Desktop, step by step, so your first report actually lets people explore data on their own terms.

Imagine you've built a bar chart showing total sales by region. It looks clean, the numbers add up, and your manager nods approvingly. Then someone asks: "Which products are driving sales in the Northeast?" You click around. Nothing happens. You scroll through three separate tables trying to piece together the answer. The meeting awkward-silences its way to a close.
This is exactly the problem that tooltips and drill-through actions were designed to solve. These two features transform a static collection of visuals into a living, navigable report — one where users can hover over a data point to see richer context instantly, or right-click a region to jump straight to a detailed breakdown page. When your report can answer follow-up questions without anyone switching tabs or rebuilding a filter, it stops being a deliverable and starts being a tool.
By the end of this lesson, you'll know how to add both default and custom tooltip pages to your visuals, configure drill-through pages that let users navigate from summary to detail with a single click, and understand the design thinking behind when to use each feature. These aren't advanced tricks — they're foundational skills for making any Power BI report genuinely useful.
What you'll learn:
This lesson assumes you've already built at least a basic report in Power BI Desktop. If you haven't done that yet, work through Your First Power BI Report in 30 Minutes before continuing. You should also be comfortable adding visuals to a canvas and understand what fields, measures, and the Fields pane are. If you need a refresher on connecting data, see Connecting to Data Sources in Power BI Desktop: Excel, CSV, SQL, and Web — A Complete Beginner's Guide.
Before touching any menus, let's establish a clear mental model of these two features, because beginners often confuse them or use the wrong one for the job.
Tooltips are popup overlays that appear when a user hovers their mouse over a data point in a visual. Think of them like footnotes that appear on demand — the chart stays in place, the user doesn't navigate anywhere, and the extra information disappears the moment the mouse moves away. They answer the question: "Tell me more about this specific data point right now."
Drill-through is a navigation action. When a user right-clicks a data point and selects "Drill through," Power BI carries that data point's context — like a region name or a product category — to a completely separate report page, pre-filtered to show only the detail for that item. They answer the question: "Take me to a full analysis of this specific item."
The key distinction: tooltips are ephemeral and contextual. Drill-through is a deliberate, page-level navigation. Use tooltips when you want to surface a quick metric or sparkline without cluttering the main visual. Use drill-through when the detail is rich enough to deserve its own page.
Key insight
Neither feature requires any DAX or complex configuration. They're controlled almost entirely through Power BI's Format and Visualizations panes. This makes them ideal for beginners to learn early.
Power BI provides automatic tooltips out of the box — no setup required. When you hover over any data point in a visual, a small popup appears showing the values of the fields bound to that visual.
For example, if you have a bar chart with Region on the X-axis and Total Sales on the Y-axis, hovering over the Northeast bar will show a tooltip that reads something like:
Region: Northeast
Total Sales: $1,247,830
This is functional, but it's also the minimum viable experience. The tooltip only knows about fields already in the visual. If you want to show, say, the profit margin or the top-selling product alongside Total Sales, the automatic tooltip won't get you there on its own.
The simplest upgrade to automatic tooltips is adding additional fields to the Tooltips field well in the Visualizations pane. Here's how:
The tooltip now shows three pieces of information: Region, Total Sales, and Profit Margin. The user gets context without you needing to add another column to the chart and sacrifice visual clarity.
Tip
You can add multiple fields to the Tooltips well — but don't add more than three or four. A tooltip crammed with ten metrics becomes unreadable and slower to render. Choose the two or three numbers that answer the most common follow-up questions.
The real power comes when you build a custom tooltip page — a dedicated report page that acts as the popup content when a user hovers. Instead of a plain text box, your tooltip can contain a mini bar chart, a KPI card, a table, or any visual combination you can build on a normal page.
This sounds complex, but the mechanism is simple: you create a small page, tell Power BI it's a tooltip page, and then point your main visuals at it.
Note
If you skip the step of enabling "Allow use as tooltip," Power BI will never recognize this page as tooltip content, no matter what you put on it. This is the most common beginner mistake with custom tooltips.
Now design the tooltip like you'd design any report page, just smaller. For our regional sales example, let's add:
To add a Card visual:
For the bar chart, add it the same way you'd add one on any page. Keep it simple — fewer than five bars, no legend, minimal axis labels. At tooltip scale, visual simplicity is usability.
Tip
Use a slightly darker or distinct background color on your tooltip page. This creates visual contrast when the tooltip overlays your main report, making it easier for users to understand what's a tooltip and what's the underlying chart. Set this under Format → Canvas background.
That's it. Now hover over any bar in your chart. Instead of a plain text tooltip, you'll see your mini dashboard — the card and bar chart — rendered as a floating panel, automatically filtered to the region your mouse is hovering over.
Key insight
Power BI automatically applies the current data point's filter context to the tooltip page. If you hover over "Northeast," the card and bar chart on the tooltip page will only show Northeast data. You don't write any filters manually — the connection is made through the report's data model relationships.
Drill-through is a different interaction pattern. Rather than a hover-triggered popup, it's a deliberate navigation where the user right-clicks a data point, sees a "Drill through" submenu, and chooses a destination page. When they arrive, the page is pre-filtered to that item.
This is ideal when the detail is substantial. Think of it as the difference between a footnote (tooltip) and a chapter appendix (drill-through page). If a regional manager wants to spend several minutes analyzing all the metrics for the Northeast — revenue trends, top customers, product breakdown, return rates — a drill-through page gives them a full canvas to work with.
The key to understanding drill-through is the concept of a drill-through field. When you designate a field as the drill-through field on a destination page, you're telling Power BI: "Any time a user navigates here from a data point, use this field's value to filter the entire page."
If your drill-through field is Region, and the user right-clicks "Northeast" on the summary page, the drill-through destination page automatically filters every visual it contains to show only Northeast data.
This filter context travels invisibly with the navigation action — you don't wire it up manually per visual. The data model's relationships do the work, which is exactly why having a well-structured data model makes features like drill-through feel effortless.
Let's build a drill-through page for our sales report. We want users to be able to right-click any region in the summary chart and drill through to a full Regional Analysis page.
This is the critical step that activates the feature.
You'll notice two things happen immediately:
Now add your detail visuals to this page. Because the drill-through field will filter everything automatically, you can add any visuals you like and they'll all respond to whichever region the user drilled from:
Warning
Avoid putting visuals on your drill-through page that use fields unrelated to the drill-through filter. If you add a "Global Market Share" donut chart that doesn't connect to the Region field through any relationship, it will show global data regardless of which region the user drilled from — which is confusing and potentially misleading.
Go back to your summary page with the sales-by-region bar chart. Right-click on any bar — say, "Midwest." In the context menu that appears, hover over Drill through. You should see a submenu with "Regional Analysis" listed as an option. Click it.
Power BI navigates to the Regional Analysis page, and every visual on that page is now filtered to Midwest data. The Back button in the top left of the page will return you to the summary view.
Tip
You can add multiple fields to the Drill through well on a destination page. If you add both Region and Product Category, users can drill through from any visual that contains either of those fields. The page will filter by whichever field was used to trigger the drill-through.
The auto-generated Back button works, but it's plain — a simple gray arrow. For a polished report, you'll want to style it. This is also an opportunity to introduce proper navigation design patterns that make your reports feel like real applications.
To style the Back button:
The most effective reports use both features together at different levels of user intent:
In our regional sales example, this means:
One action requires no commitment; the other delivers depth. Together, they serve both the executive who wants a quick overview and the analyst who wants to dig in. Combine this layered navigation with well-designed filters and slicers and you have a report that answers questions at multiple levels without ever feeling cluttered.
Apply everything in this lesson to a practice report. If you don't have your own data, use a sample dataset — Power BI Desktop includes a built-in sample. Go to File → Open report → Try a sample dataset.
Task 1 — Automatic Tooltip Enhancement: Open a report with a bar or column chart. Add at least two additional fields to the Tooltips well on that visual. Test by hovering over data points and confirming the new fields appear.
Task 2 — Custom Tooltip Page:
Task 3 — Drill-Through Page:
Stretch Goal: Style the Back button with a custom color and add a descriptive text label alongside it.
"I don't see the Drill through option when I right-click." This almost always means no field has been added to the Drill through well on the destination page. Go to the destination page, make sure nothing is selected, and check the Drill through section in the Visualizations pane. The field must be there, and it must match (or be related to) the field in the visual you're right-clicking from.
"My custom tooltip page shows all data, not filtered data." Check two things. First, confirm the tooltip page has "Allow use as tooltip" enabled under Page information in the Format pane. Second, verify that the field driving the main visual (e.g., Region) exists in your data model in a way that creates filter context — this usually means it needs to be in a dimension table connected through a relationship. If your data is a flat table with no relationships, the filter context still works, but only if the tooltip visuals use the same table.
"The tooltip page doesn't look like a popup — it looks like a full page." This happens when you haven't set a custom canvas size on the tooltip page, or the size is too large. Go to Format → Canvas settings on the tooltip page and use a custom size like 320 × 240. Power BI scales it to fit the tooltip popup dimensions.
"My drill-through page shows no data at all." Make sure you're right-clicking a data point that contains the drill-through field's value. If your drill-through field is Region but the visual you're right-clicking from doesn't contain Region in any field well (not even in a tooltip), Power BI may not pass the filter context correctly. Add Region to the main visual's Tooltips well if necessary, without displaying it in the chart axis.
Warning
If you rename a field in your data model after setting up tooltips or drill-through, the connections can break. Power BI looks for the specific field name. Always finalize your field names in Power Query before building navigation features that depend on them.
You've now added two fundamental layers of interactivity to your Power BI reports. Tooltips let users hover to surface rich context without leaving their current view. Drill-through lets users navigate to full detail pages pre-filtered to exactly the data point they care about. Together, these features transform a flat set of visuals into a report that answers questions progressively — from summary to detail, from glance to analysis.
Here's what to focus on as you practice:
When you're ready to go further with report navigation, Master Power BI Bookmarks, Buttons, and Page Navigation for Interactive Reports builds on exactly the navigation patterns introduced here. And once your report is ready to share with others, Publishing and Sharing Reports in Power BI Service: From Desktop to Enterprise Distribution walks you through getting it in front of the right people.
The report you built in this lesson is becoming something genuinely navigable. That's what separates a data presentation from a data tool.