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

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

zia_ward — Tue, 23 Nov 2021 19:06:33 GMT

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.

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

Anonymous — Fri, 26 Nov 2021 09:12:10 GMT

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.