- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Subject | Author | Posted | |
---|---|---|---|
10-30-2024 09:17 PM | |||
11-25-2024 03:22 AM | |||
11-15-2024 02:52 AM | |||
12-20-2024 10:53 AM | |||
12-08-2024 10:48 PM |