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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
mazwro
Helper II
Helper II

Treemap - how to show only filtered values and not as a proportion of a whole

I have a Treemap and a table.

 

I click a row in a table and I want the treemap to update so it only shows me categories i picked for that selection. But instead now it still shows me the whole thing with a bit coloured that is tiny. How di I change this?

 

I dont want this, I wan only the colured parts be shown

mazwro_0-1716985896624.png

 

1 ACCEPTED SOLUTION
dk_dk
Super User
Super User

Hi @mazwro ,

You can edit interactions like so:

dk_dk_3-1716987016982.png

 

 


Select the table that contains the rows you are filtering by. Go to Format, Edit Interactions. You will see in the corner of the treemap visual you will have options, you need to change it from Highlight to Filter. Then, the selection you will make in the table will instead filter the treemap. If you have multiple visuals on your page you have to configure the interactions for each, by first selecting the visual you are using for filtering, and then changing the interaction mode on the other visuals.

This is how it will look afterwars if you make a selection in the table:

dk_dk_2-1716986966141.png

 



Let me know if you have any further questions.

Best regards,
Daniel




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
dk_dk
Super User
Super User

Hi @mazwro ,

You can edit interactions like so:

dk_dk_3-1716987016982.png

 

 


Select the table that contains the rows you are filtering by. Go to Format, Edit Interactions. You will see in the corner of the treemap visual you will have options, you need to change it from Highlight to Filter. Then, the selection you will make in the table will instead filter the treemap. If you have multiple visuals on your page you have to configure the interactions for each, by first selecting the visual you are using for filtering, and then changing the interaction mode on the other visuals.

This is how it will look afterwars if you make a selection in the table:

dk_dk_2-1716986966141.png

 



Let me know if you have any further questions.

Best regards,
Daniel




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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.

Top Solution Authors
Top Kudoed Authors