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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Hiding Category Labels based on selection

Lets imagine that we are using a TreeMap of Hierarchal data.

We're Looking at Countries by Population.

 

When I click-on the largest square (The largest country by Population.) I'd like all of the other TreeMap square's "Category Label" to be hidden so that you can’t see the names of the other squares.

 

This seems like a trivial request but I've seen nothing on this topic.

 

Is this possible? If so, can the same be done for the Data Labels and how?

Regards. 

1 REPLY 1
dm-p
Super User
Super User

Hi @Anonymous,

At this time, managing data labels conditionally is not something that really works. Recently there's been an interesting solution devised where you can duplicate a series using DAX that only returns asingle data point that you can assign a value to, but I don't think this would work in the treemap scenario. It does work quite well for line charts - I've tested it out and found it quite useful.

Right now, in terms of core support, we're waiting for the Power BI team to add conditional formatting to all the things - they're getting there a bit at a time but it's not quite clear when to expect this for data labels, unfortunately.

In terms of feature requests, this is probably the idea with the highest amount of traction if you want to add your weight to it.

I appreciate this is not the answer you're looking for but wanted to let you know that you're at the same point as the rest of us with your discoveries.

Regards,

Daniel


If my post solves your challenge, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.