Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi
I am trying to do a decomposition tree but the hierarchy must be measure based and not dimension based.
I need the layout to look like the screenshot below:
As you can see it is replicating the first measure sales growth right through.
i created a table to separate to try and create a hierarch. Column 1 contains Sales Growth, Column 2 contains Growth and S, Column 3 counts U and P.
This is the measure Im using
Decomposition trees only support a single measure as the basis. All other fields must be columns.
| User | Count |
|---|---|
| 56 | |
| 42 | |
| 30 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 70 | |
| 58 | |
| 38 | |
| 22 | |
| 22 |