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

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
Anonymous
Not applicable

Storing Value from a selected value in a Matrix

I've used a Matrix to simulate a tree view for viewing a Bill of Material hierarchy, but it's rather clunky with 8 separate tables providing the source for the matrix.

BillOfMaterials.png

Matrix Rows.png

I'm trying to use the selected item number from the matrix as the filter value for other visuals on the report. I can successfully pull the value in a measure, but I can reference that value in filtering the other visuals. I'm rather new to PowerBI and any help or suggestions would be appreciated.

2 REPLIES 2
Anonymous
Not applicable

The above solution didn't work. What I'm attempting to do simply might not be possible in Power BI, but the flexibility of a Tree View for the user interaction is something that I need to dig deeper into. The filtered values passed to the other visuals on my report are as such:

mamodeo_0-1698840270749.png

and I simply need to capture and use the ChildItem as a filter value.

audreygerred
Super User
Super User

By default, the interaction between visuals is to cross-highlight, but you can change that through Edit Interactions in the Modeling tab of the ribbon, and switch it to filter, that way if you select a row in your matrix it will filter the other visuals on the page rather than cross-highlighting.

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





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

Proud to be a Super User!





Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.