Forum Discussion

zia_ward's avatar
zia_ward
Frequent Visitor
4 years ago
Solved

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

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.

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.