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

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
GopVan
Frequent Visitor

Interaction between Matrix and TreeMap

There are 3 interactions possible on a TreeMap - Filter, Highlight, and None.  My understanding is that the tile in TreeMap will get highlighted when that Category is chosen on another visual and other categories will be blurred. However, I can see no effect on the TreeMap. What am I missing?

 

DepartmentProduct Sales
A110
A220
A330
B440
B550
B660
C770
C880
C990

 

With the above data, I have created a Matrix - Product on the Rows and Sales on the Column.

 

I also have a Treemap visual with Category as Department and Values as  MeasureTreeMapSize = 1

 

GopVan_0-1671505966420.png

Question1:

I am not sure what the Highlight option is supposed to do. I can see no change on the TreeMap when a row is selected on the Matrix.

 

Question2:

If I click on "C", rows 7, 8, and 9 get filtered. But when I click on any of the filtered rows/Values in the matrix, filtering gets removed and the Rows and blurred except the row that I clicked on. In reality, my matrix has hundreds of rows, so it is hard to find which row is selected/highlighted and go to that row or even remove the selection so that other rows are not blurred anymore. I do not want the filter to be removed when I click anywhere on the matrix or at least the row I clicked to be selected/highlighted as this causes other rows to be blurred. Why is this happening?

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@GopVan , High is kind of fill, how much of overall that selected value contains.

 

You can change that using interactions

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4

 

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi @amitchandak ,

 

Thank you for the response.  As stated in your video tutorial, I have used Edit Interactions to control how the visuals behave. 

 

Let me explain the problem more clearly:

 

Slicer:

If I have a Slicer (tile), I hit on a tile the matrix rows get filtered.  Now, if I click on the values or row header part of the matrix, the filtering is still intact and does not change until I click again on the tile.

 

TreeMap:

Whereas if I have a TreeMap, I hit on the rectangle/ tile, and the rows get filtered. Now if I click on one of the filtered rows, the filtering on the Matrix is removed completely. In the Edit Interactions, I have set that the matrix should NOT affect the TreeMap's behavior.  Please see the image below for the steps to test this scenario.

 

I want the filtering on the Matrix to persist until I hit on the category again (like the behavior of a slicer).

 

GopVan_0-1671519150584.png

 

 

The only reason I am using TreeMap instead of Slicer (tile) is that I want each tile to be a different color.

 

I have attached the PBIX file as well.  Appreciate your help a lot. 

Helpful resources

Announcements
Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

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