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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.