sum and Percentage label in Decomposition tree

[Anonymous]

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

[Anonymous]

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 @Anonymous 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:

[genothampi]

Works like a charm. But there is still an issue with numbers which end with zeros.  For example, if the value if 520, instead of display it, the result show "5252000"

This persists with all values which end with zeros. Other numbers are all fine. And I am not able to find a solution for it too 🙂

[Anonymous]

It works! So much appreciated! Thank you!

[_AAndrade]

Hi @Anonymous , @Anonymous ,

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