Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.