sum and Percentage label in Decomposition tree

[v-ananyak]

want to have view like below e.i., sum and Percentage label in Decomposition tree

Thanks in advance

[_AAndrade]

Hi,

You can do it using Dynamic format for your measure, but you need to calculate that % number in order to display it.

You will find Dynamic format here:
 

Take a look this video that show some examples how use dynamic format: https://www.youtube.com/watch?v=a3D7oXYjM9k

[v-jingzhan-msft]

Hi @_AAndrade 

Thanks for this direction. I'm not able to realize it with dynamic format, can you help provide some guidance on this?

In the following image, the first part doesn't return correct result. When it doesn't include Percentage in the format, it is correct.

I don't know how to correct this. Can you help with this? Thanks in advance. 

Best Regards,
Jing

[_AAndrade · Accepted solution]

Hi @v-jingzhan-msft after some experimenting, I found a solution for this doing this:

1 - Change the data type to Text:

2 - Use this measure on the dynamic format:

VAR _Measure = COUNT('Table (2)'[Id])
VAR _Percentage = 
    [Percentage]
VAR _Result =
IF(
    _Percentage=1,
    "0" & " | " & FORMAT(_Percentage, "#%"),
    FORMAT(_Measure, "0") & " | " & FORMAT(_Percentage, "#%")
     )
RETURN
    _Result

My output was this:

[v-jingzhan-msft]

It works! So much appreciated! Thank you!

[_AAndrade]

Hi @v-ananyak , @v-jingzhan-msft ,

Did it solve your problem?
Did my message help you in any way? If it did, please mark my message as the solution and give it a "kudo", I'll appreciate it and help me out