Drill-down and drill-through in Power BI - Cell-by-Cell Formula Trace

Concept Flow

Region (Summary Level)
  |
  +-- Drill-down --> Country (Detailed Level)
  |
  +-- Drill-through --> Detailed Report Page filtered by selected Region or Country

Drill-down lets you explore data from a high-level summary (Region) to more detail (Country). Drill-through lets you jump to another report page focused on the selected data.

Formula

SUM(Sales)

This formula sums all sales values in the Sales column to get total sales.

Step-by-Step Trace

Region	Country	Sales
North America	USA	1000
North America	Canada	700
Europe	Germany	800
Europe	France	600

Total sales = 1000 + 700 + 800 + 600 = 3100

Variable Tracker

Step	Expression	Evaluates To	Explanation
1	SUM(Sales)	1000 + 700 + 800 + 600	Sum all sales values in the Sales column.
2	1000 + 700 + 800 + 600	3100	Add all sales amounts to get total sales.

Key Moments

What does drill-down do in a report?

What does drill-through do in Power BI?

Sheet Trace Quiz - 3 Questions

What does the formula SUM(Sales) calculate in this data?

A The sales for only North America

B The average sales per country

C The total sales across all regions and countries

D The sales for Europe only

Key Result

Drill-down lets you explore data from summary to detail within the same visual. Drill-through lets you jump to another report page filtered by the selected data for deeper insights.

Transcript

Imagine you have sales data summarized by region. Drill-down lets you click on a region to see sales by country inside that region. Drill-through lets you click on a region or country and open a new report page that shows detailed information filtered just for that selection. The SUM(Sales) formula adds all sales values to get total sales. This helps you understand the total amount before drilling down or through for details.