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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.