Decomposition tree is an amazing but lesser known (and used) visual in Power BI. It is a native visual and it is designed for data brainstorming (a term I coined to describe this visual). Learn why and how to use it and also when to use it. Watch this interesting video 15 min video.
Watch video
Table of contents – Decomposition tree
- Introduction – 00:00
- Create Decomposition Tree visual – 00:25
- Use the Decomp Tree – 02:21
- Display options – 03:00
- Conditional formatting – 05:00
- AI based exploration – AI Split – 05:36
- Manual vs AI split – 08:19
- Locking levels – 08:50
- Decomp tree with other visuals – 09:20
- When to use this visual? – 10:46
- Decomp tree inside regular report – 11:20
- Decomposition tree with page tooltip – 12:49
- Summary – 13:32
TL;DR
- Use this for open ended, interactive exploration of your data
- Add the main parameter to analyse – a numeric aggregation like sales, revenue, cost, etc.
- Add other dimensions or fields which influence the key parameter
- Now click the plus sign and choose the fields to break down the earlier level
- Use High value / Low value to automatically choose the field
- Use with other visuals for cross filtering and visual what-if analysis
- Use with page tooltips to get details for any node
- Add the decomp tree visual in regular reports as well. This way, you can create
Decomposition tree Related content
- Power BI Modern Tooltips
- Excel vs Power BI – differences and common features
- Excel and Power BI Event
- High, Medium, Low – visual categories – In-Depth
- Common mistake – Power BI free version not used
—