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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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

 

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

 

İf this post helps, then please consider Accept it as solution and kudos to help the other members find it more quickly.

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

 

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

 

İf this post helps, then please consider Accept it as solution and kudos to help the other members find it more quickly.

Helpful resources

Announcements
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 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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