How to change the data label in a hierarchical tree chart

[juniorjfd]

Hello everybody!

I received a request from a customer, in which she asked for the hierarchical tree data label to be changed, but I'm not getting it.

Basically, I need each step of the hierarchical tree to show as a data label, the percentage in relation to the total of the previous step.

Below is the chart. You can see that the data label contains the total for each category, but what I need is to show the percentage in relation to the previous step. For example, in the step "1ª Rechamada", in the first category "AGENDAMENTO REAPAR...", instead of showing the value "107", I need it to show "26.35%", that is, 107 of the current category divided by 406 of the previous step.

Can you help me?

[juniorjfd]

Thank you very much! It finally worked!

[MFelix · Accepted solution]

Hi @juniorjfd 

For this you need a measure similar to the one below:

test = 
SWITCH (
    TRUE (),
    ISINSCOPE ( 'Table'[sub] ), DIVIDE ( [count], CALCULATE ( [count], ALLSELECTED ( 'Table'[sub] ) ) ) * 100 ,
    ISINSCOPE ( 'Table'[CAt] ), DIVIDE ( [count], CALCULATE ( [count], ALLSELECTED ( 'Table'[CAt] ) ) )* 100,
    [count]
)

Be aware that for this to work you need to have the order of the columns to be in the same order has the decomposition tred, if you change the order the values will be strange.

Another thing is what do you want to show on the first value is it the value or the percentage, has tyou can see my value is multiplied by 100 to get the value correct but it does not show the % value, we can do it with a use of the tabular editor to have a condittional formatting applied.