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 th...
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.

     

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.