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
Stelvio1200
Regular Visitor

Filter existing matrix by clicking item in matrix

Good day. I have built a dashboard that has a simple matrix table. I have added slicers to filter the data. That all works perfectly. My table has 6 columns, one named Items. Here is an Excel mock up of the table:

 

Stelvio1200_0-1733847091457.png

I have a dropdown slicer for the Items column and if I select Item 3 the table is filtered to only show those that have Item 3 associated with them as follows (notice Combo 00002_0002 has been filtered out):

 

Stelvio1200_1-1733847249264.png

What I would like to do is perform this same function but instead of having to use the dropdown slicer, I want the filter to occur if the person using the dashboard clicks Item 3 anywhere in the matrix itself. 

 

I dabbled with "Edit Interactions" a bit but that doesn't seem to be the correct path in this case. 

 

Is this even possible? 

 

Thanks. 

 

2 REPLIES 2
lbendlin
Super User
Super User

No, not possible. It violates the UX guidelines.

Thank you Ibendlin. Not the answer I was hoping for but glad to know that there is a reason I couldn't figure it out. Learning is wonderful. Happy Holidays my friend. 

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!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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 Kudoed Authors