Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
neha_parmar24
New Member

Replace data value in Treemap without transformation

Hello All , 

 

I'm using the TreeMap visual in one of my reports. The value from the database is highlighted; I want to replace it with measures in the Tree map.I tried measure and it did not replace the value; yet, the same measure works for other visuals such as tables but not for Treemaps.

Please help me on this.

neha_parmar24_3-1723631802005.png

 

Filter1 =
var level1 = FIRSTNONBLANK('Dim A'[Level1],'Dim A'[Level1])
return
SWITCH(level1,"NO_BPIGROUP","ABC",level1)

 

1 ACCEPTED SOLUTION
uzuntasgokberk
Super User
Super User

Hello @neha_parmar24 ,

 

In treemap visualization, Details and Category needs to be column. Measure can't be put on the Details and Category. Measure only can be used on Values and Tooltips in TreeMap visualization.

"Power BI uses the measure value to determine the rectangle size for branches and leaves."

Treemaps in Power BI - Power BI | Microsoft Learn

 

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

View solution in original post

1 REPLY 1
uzuntasgokberk
Super User
Super User

Hello @neha_parmar24 ,

 

In treemap visualization, Details and Category needs to be column. Measure can't be put on the Details and Category. Measure only can be used on Values and Tooltips in TreeMap visualization.

"Power BI uses the measure value to determine the rectangle size for branches and leaves."

Treemaps in Power BI - Power BI | Microsoft Learn

 

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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