Forum Discussion

swwong1's avatar
swwong1
Helper 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 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

  • 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.

  • 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.

  • 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's avatar
      swwong1
      Helper III

      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!