cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jstern1 Frequent Visitor
Frequent Visitor

Help change Treemap Data Label from Blank to Something Else

Hi Guys,

 

Simply put, does anyone know how to change specific data labels for the treemap visualization?

 

For example, I have a treemap that shows the top-10 clients, but for one of them the name apears as (blank).

 

Is there a way where I can replace "(blank)" with another name?

 

Thanks!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Help change Treemap Data Label from Blank to Something Else

@jstern1 leave that blank or type null






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

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

3 REPLIES 3
Super User
Super User

Re: Help change Treemap Data Label from Blank to Something Else

@jstern1 seems like you have blank value in your table, why not replace blank value with the name you want in power query and it will flow thru to treemap or any other visual.






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

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





jstern1 Frequent Visitor
Frequent Visitor

Re: Help change Treemap Data Label from Blank to Something Else

Hi Parry,

 

I've gave that a try but it led to some errors.  

 

If i'm trying to replace the blanks, in the "value to find" box, should I just leave that blank?

 

Thanks again.

Super User
Super User

Re: Help change Treemap Data Label from Blank to Something Else

@jstern1 leave that blank or type null






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

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,704)