Forum Discussion

swwong1's avatar
swwong1
Icon for Helper III rankHelper III
5 years ago
Solved

Concatenate Measures for Data Labels in Tree Map

Hi All   I have used the RANKX function to find the top 10 clients in a tree map but instead of the default data labels such as showing client name and revenue; I would like to show the client and ...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, swwong1 

    I guess I got the result you want. Please check the result below.

    In the following result, I didn't make any changes to your source file. I just tried to change the displayed fields and settings in the properties

    Please refer to the attachment below for details

     

     

    Is this the result you want? Hope this is useful to you

    Please feel free to let me know If you have further questions

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, swwong1 

 

Try to create a calculate column to concatenate Measures

_Concatenate column =
CONCATENATE (
    'DATA'[Client],
    "(" & FORMAT ( 'DATA'[% of Selected], "Percent" ) & ")"
)

Sample:

I changed your fields like this:

Result:

Please refer to the attachment below for details

 

 

Is this the result you want? Hope this is useful to you

Please feel free to let me know If you have further questions

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.