Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
a68tbird
Resolver II
Resolver II

Treemap Help

Hello All -

   My dashboard uses the Treemap visualization (which I think is really great), but when the user starts to drill down into some of the lower value (ie. smaller squares) areas, it is difficult to identify what the grouping is. The information that appears on mouse hover is exactly the information that I would like to put onto a card (or similar).  Is this possible? My treemap groups by account and product type.  If I just put the product type onto a card, it returns a numeric value (Count of product type).  

 

Of course I realize that this information would have to be two values (account and product type) and that when the treemap has not been drilled down at all...well, I'm not entirely sure what would happen (it would try to show all, which would be a mess!).

 

Anyone have any suggestions?

 

Thanks!

Travis

1 REPLY 1
WillT
Community Admin
Community Admin

You've got two options: - use the 'Multi-row Card' visual, just drop the product type field onto it. - Use the 'Card' visual but to do this you'll need to create a measure for the field you want. It can return text, but you'd need to wrap the field in a function of some sort. For example =FIRSTNONBLANK([ProductType]), or =CONCATENATEX(Products, [ProductType], ", ") Hope that helps!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.