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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Regular Visitor

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.


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.

Regular Visitor

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:


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

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. 

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

Proud to be a Super User!

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.