cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.





Highlighted
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 Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)