Reply
avatar user
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)




avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)