Power BI Decomposition Tree Data Label (Total and %Node)

[zia_ward]

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.

[Anonymous · Accepted 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.