# Decomposition tree

## Chart setup to build a decomposition tree:

{% stepper %}
{% step %}

#### **Axis**

Drag the dimensions you want to use to break down and analyze the measures (e.g., Region, Category).
{% endstep %}

{% step %}

#### **Values parameter**

Drag multiple measures to analyze (e.g., Units sold, Revenue).
{% endstep %}

{% step %}

#### **Chart type**

Select **Decomposition Tree** from the Hierarchy section of the Chart Type dropdown menu.
{% endstep %}
{% endstepper %}

> A Decomposition Tree visual in Power BI allows you to analyze one measure through multiple categorical dimensions, one level at a time. It provides an interactive, hierarchical view where each branch represents a breakdown of the total value, letting users explore “what contributes to what” in a clean, structured way.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Ftm3jkw2sQx63HHlxlIP7%2Fimage.png?alt=media&#x26;token=13c24b5f-acb1-439d-916e-47fd93a68d19" alt=""><figcaption><p>Decomposition tree with pivot data</p></figcaption></figure>

## **Customization & formatting under canvas settings**

Use canvas settings to control the look and behavior of your chart. It contains two tabs - General and Decomposition Tree.

#### 1. Decomposition tree format

Under the General settings tab, enable the toggle to customize the color for each parent node category.&#x20;

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F5GtBJ1P0hkAEKwwPzy2m%2Fimage.png?alt=media&#x26;token=61df4f0d-ee2c-4923-a49d-d1e5c8863b89" alt=""><figcaption><p>Custom color formatting</p></figcaption></figure>

#### 2. Show Header

Enable this toggle to display the selected dimension category hierarchy and the corresponding highest and lowest values at the top of the visual.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FfCd0ux6Y8ob7gDDliAUk%2Fimage.png?alt=media&#x26;token=58073829-9885-4ca4-8c14-ebe3cc2d7b89" alt=""><figcaption><p>Show header for decomposition trees</p></figcaption></figure>

#### 3. Tree

**3.1. Density**

Density settings - Dense, Default, and Sparse, allow you to control how compact or spaced out the tree layout appears.

* **Dense**: Displays branches close together, allowing more information to be fit on a single screen, making it ideal for detailed analysis or larger hierarchies.&#x20;
* **Default**: Offers a balanced layout with moderate spacing, providing a clean and readable visual for most use cases.&#x20;
* **Sparse**: Adds extra spacing between nodes and branches, improving clarity and focus during presentations or executive reporting.&#x20;

<div><figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FWtv2atOl2hauqjcrt4xH%2FDense.png?alt=media&#x26;token=516a3838-f753-405c-a893-e2dda2e3c9bb" alt=""><figcaption><p>Dense</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Fhahm32dBRLchkx1xlsy3%2Fsparse.png?alt=media&#x26;token=76cef8a0-19ff-4521-86af-8e1b265855ff" alt=""><figcaption><p>Sparse</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FpcTelV4lerP1kbvNFxg3%2Fdefault.png?alt=media&#x26;token=a605c2fd-bcdb-4cc2-a163-cd24b5f43d28" alt=""><figcaption><p>Default</p></figcaption></figure></div>

**3.2. Default action**

* **Filter/Highlight:** Highlights or filters data related to the selected node, allowing you to focus on specific segments while maintaining an overall view.&#x20;
* **Collapse:** Automatically folds the branch when selected, keeping the visual neat and organized, especially in large or complex hierarchies.&#x20;

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FthYbUBXNO1iqk3YeqHO6%2Fimage.png?alt=media&#x26;token=4c175525-f963-4753-aeec-ad67e9a6b158" alt=""><figcaption><p>Default action options</p></figcaption></figure>

<div><figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FwM2uLLas1MMgqjOzOoDB%2FUntitled%20Project.gif?alt=media&#x26;token=0d7b858d-bc4c-4446-9ae1-6eea5a195a0b" alt=""><figcaption><p>Filter/Highlight</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FwOH7C9irxgACgp9AgBBI%2FUntitled%20Project.gif?alt=media&#x26;token=e1b6183f-eab5-446a-8725-668130075f45" alt=""><figcaption><p>Collapse</p></figcaption></figure></div>

**3.3. Expand level**

Set the default level to expand the hierarchy.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FTaizrN5VaeDxbBzlrIpa%2FUntitled%20Project.gif?alt=media&#x26;token=3ec6d0db-5c7d-4d1f-99c8-2dd83fb363fa" alt=""><figcaption><p>Expand level</p></figcaption></figure>

**3.4. Responsive level**

Enable the responsive toggle for the tree to adjust levels automatically based on space.\
Disable the toggle to display a fixed number of levels. This gives you full control when you need a specific layout.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F3FFQC5qtfNk7PpivZ0Vk%2FUntitled%20Project.gif?alt=media&#x26;token=d35e1952-8d91-4030-af84-cfa5fb05972d" alt=""><figcaption><p>Levels automatically adjusted according to canvas size </p></figcaption></figure>

**3.5. No of bars**

Depending on the number of categories in your data, you can control how many to display.

<div><figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F3H58fEmg6jbZttiuDCu3%2FBars.png?alt=media&#x26;token=e46222b0-31bb-4aa4-8551-f4fd5416fdb7" alt=""><figcaption><p>4 bars</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FRv1sistxTE7XzHpGC1BD%2Fbars8.png?alt=media&#x26;token=e970eb61-cf25-4930-b6a2-3a7a75dd622a" alt=""><figcaption><p>8 bars</p></figcaption></figure></div>

**3.6. Line style**

Choose between dotted, dashed, and regular connector lines. Set the line thickness.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FAqTO4stiKiSecAs5XJeF%2Fimage.png?alt=media&#x26;token=f477b7cf-5d2b-4b76-843e-2e63f49a015b" alt=""><figcaption></figcaption></figure>

**3.7. Line type**

Choose between Curved line, Spline, Line, and Straight line types for the connector lines.

<div><figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F4xCOTFzFNdyuW1NEMHS8%2Fcurevd%20line.png?alt=media&#x26;token=04274a49-eef6-4d07-9f10-552e243d8e42" alt=""><figcaption><p>Curved line</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FC9lpEMNOB4WwLznldtIv%2Fspline.png?alt=media&#x26;token=d122ba25-5cfb-4bb2-98ea-f82822df3b5f" alt=""><figcaption><p>Spline</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FTMuYiThJAPP5oAWJHcto%2FLine.png?alt=media&#x26;token=31dac26d-e2a5-465f-8720-25ea99fa6f73" alt=""><figcaption><p>Line</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F2jqy6o98MLzU4kHQUf3J%2FStraight%20Line.png?alt=media&#x26;token=a6694d30-1d5a-4a20-a9d4-aa1acdaeeb92" alt=""><figcaption><p>Straight line</p></figcaption></figure></div>

**3.8. Show arrow**

Enable this toggle to display arrows at the end of connector lines.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Ftc4hN6pyIqkhjoyB8xrA%2Fimage.png?alt=media&#x26;token=98ed611b-038a-4920-b8f2-7e99dd026a5b" alt=""><figcaption><p>Show arrow</p></figcaption></figure>

**3.9. Selected line**

Set a custom color to highlight connector lines when a node is selected in reading view.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FGQqkKEHbWO4uxnwmmhOd%2Fimage.png?alt=media&#x26;token=f21d81b6-2470-4773-8af2-b3a5d2348fdb" alt=""><figcaption><p>Selected line</p></figcaption></figure>

**3.10. Unselected line**

Similar to the Selected line option, this allows you to set a color for the connector lines.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FCXEM0yRgd66waMRKtY9c%2Fimage.png?alt=media&#x26;token=ae53f095-afad-4c62-a716-f31dc1d4d3b3" alt=""><figcaption><p>Unselected line</p></figcaption></figure>

#### 4. Bar

**4.1. Type**

Display the nodes as progress bars, tiles, or cards.

<div><figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FNmWlDir3hPAg5TlytC4L%2FCard.png?alt=media&#x26;token=53649a29-1864-4f5e-b70e-0dca89e0ce85" alt=""><figcaption><p>Card</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FBdsRxlghfHWjj3RthylK%2FTile.png?alt=media&#x26;token=f99f14b9-1d45-4cc1-b5bc-45bff07cb0ec" alt=""><figcaption><p>Tile</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FDqP1aYei1pIe0vFuk7xt%2FProgressBar.png?alt=media&#x26;token=b3dfc775-a566-4227-b2a0-cea035a469f5" alt=""><figcaption><p>Progress bar</p></figcaption></figure></div>

**4.2. Size**

Set the width and height of each node.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FNfoYmn4O9yf19SFw3SUc%2Fimage.png?alt=media&#x26;token=9706127e-bd8e-4bbe-a7e6-eb7f4b4104ea" alt=""><figcaption></figcaption></figure>

**4.3. Scale to**

Control how values are scaled and compared across different hierarchy levels with the different options available :

* **Top Node**: Scales all values relative to the root node, providing a view of the contribution to the overall total.&#x20;
* **Parent Node**: Displays each child node’s value as a percentage of its direct parent, ideal for analyzing proportional relationships within a hierarchy.&#x20;
* **Level Maximum**: Scales values based on the highest value within each level, helping you easily identify top performers at every stage and compare relative contribution within a single level.&#x20;
* **Custom:** Lets you define your own scaling logic by providing start and end input values as per your data.

{% hint style="success" %}
This option is available for Card and Progress Bar types.
{% endhint %}

<div><figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FHPGbCx7mfi50HT2Ie9YB%2FTopNode.png?alt=media&#x26;token=fe0873e9-5a94-4938-842a-99265d0c0f04" alt=""><figcaption><p>Top node</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F7hJBkqLOZWiYVbI5fCbl%2Fcustom.png?alt=media&#x26;token=41655c1d-097c-444d-80df-af529d894e5a" alt=""><figcaption><p>Custom</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FDNeltbIUKtjwseSdsj0x%2FLevelMaximum.png?alt=media&#x26;token=a31e3b5c-7674-4985-bb94-eaf30998be6f" alt=""><figcaption><p>Level maximum</p></figcaption></figure> <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FEHkI0jLAXKhqAaPpMSqB%2FParentNode.png?alt=media&#x26;token=bab28cfa-46e7-468d-8293-e96c4b19fb8b" alt=""><figcaption><p>Parent node</p></figcaption></figure></div>

**4.4. Radius**

Adjust the corner radius of each node.

{% hint style="success" %}
This option is available for Tile and Progress Bar types.
{% endhint %}

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FgXnSrJh8K0CLWezFL3KC%2Fimage.png?alt=media&#x26;token=5089e04c-a77a-46b7-b757-78689bcf2f98" alt=""><figcaption><p>Radius option</p></figcaption></figure>

**4.5. Background**

Set a custom background color for the progress bar.

{% hint style="success" %}
This option is available for Card and Progress Bar types.
{% endhint %}

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Fl2CikEn9c33hDaDtRppl%2Fimage.png?alt=media&#x26;token=7ad257ed-fe9f-41fb-9f7d-7776ae2fb1fc" alt=""><figcaption><p>Background option</p></figcaption></figure>

**4.6. Border**

Set a custom border color for cards.

{% hint style="success" %}
This option is available for the Card type.
{% endhint %}

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Fa4kU0cS7zqcFvLNskng7%2Fimage.png?alt=media&#x26;token=1cacc335-7aa7-412f-b351-60069b77b521" alt=""><figcaption><p>Border option</p></figcaption></figure>

**4.7. Card background color**

Set a custom background color for cards.

{% hint style="success" %}
This option is available for the Card type.
{% endhint %}

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FDkRM1kGzMo2480tJ1IsA%2Fimage.png?alt=media&#x26;token=73e99712-a1d4-4b59-a2ee-8a363d53567f" alt=""><figcaption><p>Card background color</p></figcaption></figure>

## Data label settings

#### 1. Show child count

Enable this toggle to view the number of children under each parent node.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FMdFGPKoD6vbXXJaotBpC%2Fimage.png?alt=media&#x26;token=ff26b959-1fae-4bcc-88e7-3eba990e31b1" alt=""><figcaption><p>Show child count</p></figcaption></figure>

#### 2. Label type

Select the Percentage option to display the percentage contribution of each category.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FEhwQvVInzx9Xrk5GeJ9f%2Fimage.png?alt=media&#x26;token=001b6bbb-b963-45c5-b544-c57cea4d6f03" alt=""><figcaption></figcaption></figure>

## Additional Formatting Options

Here are the other settings that help you refine your decomposition tree.

<table><thead><tr><th width="143.5">Feature</th><th>Description</th><th data-type="content-ref">Link</th></tr></thead><tbody><tr><td>Number</td><td>Configure number formatting (decimals, units)</td><td><a href="../working-with-analytics+/3.-charts/3.8.-display-settings-for-charts/charts-number-settings">charts-number-settings</a></td></tr><tr><td>Legend</td><td>Show/hide and customize the legends</td><td><a href="../working-with-analytics+/3.-charts/3.8.-display-settings-for-charts/charts-legend-settings">charts-legend-settings</a></td></tr><tr><td>Data Label</td><td>Show exact values for each data point</td><td><a href="../working-with-analytics+/3.-charts/3.6.-data-label-customizations">3.6.-data-label-customizations</a></td></tr><tr><td>Trellis</td><td>Create small multiples using category split</td><td><a href="../working-with-analytics+/6.-trellis-customizations">6.-trellis-customizations</a></td></tr><tr><td>Conditional Formatting</td><td>Apply color rules to highlight values</td><td><a href="../working-with-analytics+/9.-conditional-formatting">9.-conditional-formatting</a></td></tr><tr><td>Sorting</td><td>Sort axis order</td><td><a href="../working-with-analytics+/10.-sort-and-reorder-data/sorting-data">sorting-data</a></td></tr><tr><td>Ranking</td><td>Limit to top/bottom N categories</td><td><a href="../working-with-analytics+/11.-ranking-data-topn/ranking-for-charts">ranking-for-charts</a></td></tr></tbody></table>
