? Drill-Down & Drill-Through

? Quick Overview

Drill features in Power BI help users move from summary-level insights to detailed-level data interactively, without cluttering reports.

? Key Concepts

• Drill Down works inside the same visual
• Drill Through navigates to another page
• Both depend on hierarchies and filters
• Used heavily in business dashboards

? Syntax / Theory

Drill features do not use DAX directly. They work through:

• Hierarchies (Year → Month → Day)
• Visual-level interactions
• Filter context passing

? Sample Practice Data

// Sales hierarchy dataset
Year,Quarter,Month,City,Product,Sales
2024,Q1,Jan,Pune,Mobile,15000
2024,Q1,Feb,Mumbai,Laptop,45000
2024,Q2,Apr,Delhi,Mouse,5000
2024,Q2,May,Pune,Keyboard,3000
2024,Q3,Aug,Mumbai,Camera,35000

? Where to Use Drill Options

1. Open Power BI Desktop
2. Load Data
3. Go to Report View
4. Create Chart (Bar / Column / Matrix)
5. Add Hierarchy Fields
6. Use Drill Icons on Visual

1️⃣ Drill Down — Complete Explanation

Drill Down allows users to move deeper into a hierarchy within the same visual.

? Step-by-Step Practical (Drill Down)

1. Create Column Chart
2. Add Year → Quarter → Month to Axis
3. Turn on Drill Mode
4. Click bar to move to next level

2️⃣ Drill Through — Complete Explanation

Drill Through opens a different report page showing detailed information for the selected value.

? Step-by-Step Practical (Drill Through)

1. Create New Page
2. Add detailed table visual
3. Drag field into Drill Through filter
4. Right-click data point → Drill Through

? Live Output / Explanation

? Interactive Concept Flow

// Conceptual interaction flow
User clicks data point
Power BI applies context
Visual or page updates
User sees deeper insights

? Use Cases

• Sales → Country → State → City
• Finance → Year → Quarter → Month
• HR → Department → Employee