Concatenate Measures for Data Labels in Tree Map

[swwong1]

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 then the % of top 10 revenue for that client.

Eg. For Client F, instead of showing 'F $897'; I was hoping to see 'F (17%)'

https://www.dropbox.com/s/fjt415in3cgzqy4/RANKX.pbix?dl=0 

Many thanks for your help

[v-angzheng-msft · Accepted solution]

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.

[swwong1]

Hi @v-angzheng-msft 

Thanks for this. I guess I was too focused on making sure the box size is proportional to the 'revenue'. However, the % would also make the size be proportional too!

[swwong1]

@v-angzheng-msft 

Thanks for the above. I have looked into this and used COMBINEVALUES to join them together but as it was a measure, I couldn't add this to 'details' in the tree map.

In your solution, you have joined them through calculated columns but if you look at the % it is slightly different as I have 12 clients in total (but tree map only shows top 10). The calculated column isn't taking into account the filter context so it is showing the % of all 12 clients, instead of % of top 10 clients.

[v-angzheng-msft]

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.