Solved: Help change Treemap Data Label from Blank to Somet...

Anonymous · ‎07-09-2019

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!

parry2k · ‎07-09-2019

@Anonymous leave that blank or type null

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

parry2k · ‎07-09-2019

@Anonymous 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.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎07-09-2019

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.

parry2k · ‎07-09-2019

@Anonymous leave that blank or type null

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.