How to Filter a Raw Data Table Based on Matrix Selection in Power BI?

Hi PBI_KN8

It is a limitation with how Power BI handles interactions with matrix visuals when you’re using calculated measures like % COMPLETED.

Basically, when you click on a value like “Met 30 Days” in the matrix, it doesn’t actually pass that filter down to your raw table because that value comes from a measure, not a field/column. So your raw data table doesn’t know what to filter by.

You can try these steps :

1. Unpivot your data so “Met 30 Days”, “Met 60 Days”, etc. are actual values in a column  that way clicking on them works just like any other slicer or column filter.

2. Or, if restructuring the data isn’t an option, you can use a disconnected table with values like “Met 30 Days”, use SELECTEDVALUE() to capture the selected item, and then use that in your filtering logic on the raw data.

Both methods are solid, just depends how flexible your model is.