Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am using Power BI Decomposition tree. The value that I decompose is total sales. The decomposition tree shows the data label as the value within each branch. I would also like to show the node sales as a percentage of the previous node's total sales. How can I achieve this?
Example: Root ($500 sales, 100%)
Node 1: ($400 sales, 80%)
Node 2: ($100 sales, 20%)
Thanks.
Solved! Go to Solution.
Hi @zia_ward ,
My Sample is as below.
Create a Percentage measure and add this measure in tooltips.
Percentage % =
VAR _Sales = SUM('Table'[Sales])
VAR _Total = SUMX(ALL('Table'),'Table'[Sales])
RETURN
DIVIDE(_Sales,_Total)
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @zia_ward ,
My Sample is as below.
Create a Percentage measure and add this measure in tooltips.
Percentage % =
VAR _Sales = SUM('Table'[Sales])
VAR _Total = SUMX(ALL('Table'),'Table'[Sales])
RETURN
DIVIDE(_Sales,_Total)
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |