Drill-Down & Drill-Through Reports

Drill-down and drill-through are two powerful navigation features that allow users to explore data at different levels of detail.

Drill-Down (Within a Visual)

Drill-down lets users navigate through hierarchies within a single visual — from a high-level summary to granular details.

Pre-requisite: The visual must have a hierarchy on its axis (e.g., Year → Quarter → Month).

Drill-Down Controls

Drill-Down Example

Hierarchy: Country → State → City → Store

1. Start: Chart shows sales by Country (India, USA, UK)
2. Click India: Drill down to States (Maharashtra, Karnataka, Delhi)
3. Click Maharashtra: Drill down to Cities (Mumbai, Pune, Nagpur)
4. Click Mumbai: Drill down to Stores
5. Drill Up: Return to previous level

Drill-Through (Across Pages)

Drill-through navigates users to a different report page with detailed information about the selected data point.

How It Works:

1. Create a detail page (e.g., "Product Details")
2. Add fields to the Drill-through filters well on that page
3. On the summary page, right-click a data point → Drill through → Select the detail page
4. The detail page opens, filtered to the selected data point
5. A Back button is automatically added for return navigation

Setting Up Drill-Through

Steps:

1. Create a new report page (e.g., "Customer Details")
2. Design the page with detailed visuals (tables, charts, KPIs)
3. In the Visualizations pane → drag a field (e.g., CustomerName) to the Drill through filter area
4. On your main page, right-click a customer in any visual
5. Select Drill through → Customer Details
6. The detail page shows data filtered to that specific customer

Cross-Report Drill-Through

Navigate from one Power BI report to another entirely different report.

Setup:

1. Enable cross-report drill-through in both reports
2. File → Options → Current File → Report Settings
3. Check "Allow visuals in this report to use drill-through targets from other reports"

Drill-Down vs Drill-Through