Decomposition tree in Power BI - Dashboard Guide

Dashboard Mode - Decomposition tree

Business Question

Which product categories and subcategories contribute most to total sales, and how do regions affect these sales?

Sample Data

Category	Subcategory	Region	Sales
Furniture	Chairs	East	100
Furniture	Tables	West	150
Technology	Phones	East	200
Technology	Accessories	West	120
Office Supplies	Paper	East	80
Office Supplies	Binders	West	90

Dashboard Components

• KPI Card: Total Sales with formula Total Sales = SUM(Sales[Sales]). Result: 740
• Decomposition Tree Visual: Breaks down Total Sales by Category, then Subcategory, then Region. This lets users explore which categories and regions drive sales.
• Table: Shows detailed sales by Category, Subcategory, and Region for reference.

Dashboard Layout

+----------------------+-------------------------+
|      KPI Card        |   Decomposition Tree     |
|   (Total Sales)      |                         |
+----------------------+-------------------------+
|                      |                         |
|       Table          |                         |
| (Sales Details)      |                         |
+----------------------+-------------------------+

Interactivity

The decomposition tree is interactive. Clicking on a Category expands to show Subcategories, then Regions. Selecting a node filters the table below to show only relevant sales details. The KPI card updates dynamically to reflect the filtered total sales.

Self Check

Add a filter to select only the Technology category. Which components update and what is the new total sales?

• The KPI card updates to show total sales for Technology: 320 (Phones 200 + Accessories 120).
• The decomposition tree shows only Technology category branches.
• The table filters to show only Technology sales rows.

Key Result

Interactive decomposition tree dashboard showing total sales broken down by category, subcategory, and region with dynamic KPI and detailed table.