Treemap in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sales data by Category and Subcategory with sales amounts.

Cell	Value
A1	Category
B1	Subcategory
C1	Sales
A2	Fruits
B2	Apples
C2	100
A3	Fruits
B3	Bananas
C3	150
A4	Vegetables
B4	Carrots
C4	80
A5	Vegetables
B5	Broccoli
C5	120

Formula Trace

SUM(Sales) by Category and Subcategory for Treemap size

Step 1: Group data by Category and Subcategory

Step 2: Calculate sum of Sales for each group

Step 3: Calculate total sales for each Category

Step 4: Assign rectangle sizes proportional to sales sums

Cell Reference Map

    A          B          C
1 |Category |Subcategory| Sales |
2 | Fruits  | Apples    |  100  |
3 | Fruits  | Bananas   |  150  |
4 |Vegetables| Carrots  |  80   |
5 |Vegetables| Broccoli |  120  |

The treemap uses Category (A), Subcategory (B), and Sales (C) columns to group and size rectangles.

Result

Treemap Visualization:
+-----------------------------+
| Fruits (250)                |
|  +-----------+------------+ |
|  | Apples(100)| Bananas(150)| |
+-----------------------------+
| Vegetables (200)            |
|  +----------+-------------+ |
|  | Carrots(80)| Broccoli(120)| |
+-----------------------------+

The treemap shows two main rectangles for Fruits and Vegetables sized by total sales. Inside each, smaller rectangles represent subcategories sized by their sales.

Sheet Trace Quiz - 3 Questions

What determines the size of each rectangle in the treemap?

A The number of subcategories only

B The alphabetical order of Categories

C The sum of Sales for each Category and Subcategory

D The average sales per subcategory

Key Result

Treemap groups data by category fields and sizes rectangles by sum of a numeric measure.