Drill-Down, Drill-Through & Tooltips

Power BI · Data Visualization

Theory

Power BI offers three ways to reveal more detail on demand. Drill-down works inside one visual that has a hierarchy on its axis, such as Year → Quarter → Month or Category → Product: with drill mode on, clicking a bar moves to the next level, so clicking Electronics shows Headphones and Keyboard. You can create a hierarchy in the Data pane by dragging one column onto another.

Drill-through jumps to a separate detail page. You add a field, for example Customers[Name], to the target page's Drill-through well; then right-clicking Asha anywhere in the report and choosing Drill through opens that page filtered to Asha, and a back button returns. Tooltips appear on hover: by default they list the visual's fields, but a report page tooltip is a small page that shows its own visuals, such as a mini trend for the hovered region.

Why we use it

Summary pages stay clean while detail is one click away. Users explore from overview to specifics without leaving the report or building extra filters.

When to use it

Use drill-down for natural hierarchies within one chart, drill-through for a full detail page about one item (customer, product), and tooltips for quick context without clicking. Do not hide essential information only in tooltips; they are not visible on touch screens until tapped.

How it works

  1. User wants more detail
  2. Stay in the same chart, next hierarchy level? Yes: Drill down. No: Continue.
  3. Need a full page about one item? Yes: Drill through to the detail page. No: Hover for a tooltip.
  4. Detail is shown with the right filters
  5. Return via back button or drill up

Syntax

Hierarchy: Data pane → right-click column → Create hierarchy (or drag a column onto another)
Drill-down: visual header → down-arrow (drill mode) or right-click → Drill down
Drill-through: target page → Visualizations → Drill through well → add field
Page tooltip: Format page → Page information → Allow use as tooltip; then visual → Format → General → Tooltips → Type: Report page

Example

1. Create hierarchy: Products[Category] → Products[Product].
2. Bar chart with the hierarchy and [Total Sales]: Electronics ₹4,200, Home ₹2,000.
3. Drill mode on, click Electronics → Headphones ₹1,800, Keyboard ₹2,400.
4. New page 'Customer Detail': add Customers[Name] to Drill through.
5. On any page right-click Asha → Drill through → Customer Detail shows her 2 orders, ₹2,700.

Key points

Power BI topics

Power BI Introduction

Getting Data

Power Query (Data Transformation)

Data Modeling

DAX (Data Analysis Expressions)

Data Visualization

Dashboards & Reports

Power BI Service

Advanced Features

Projects & Case Studies

Interview & Certification

Advanced DAX & Time Intelligence

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Power BI Dashboards & DAX

Learn data visualization and interactive dashboards step-by-step. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice DAX Online 250 business scenarios on a star schema — write a measure and compare your visual with the expected one. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Power BI  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax / Where to find it
{{ current.syntax }}
Example
{{ current.example }}
What You'll Learn — click to check off
  • {{ pt.mark }} {{ pt.text }}

Share this topic