Forum Discussion
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 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
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.
4 Replies
- v-angzheng-msftCommunity Support
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. - swwong1Helper III
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-msftCommunity Support
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.- swwong1Helper III
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!