Matrix filter on a column values

Question

Hi&nbsp;I have a matrix visual. I am trying to filter based on specific values based on the columns.&nbsp;There are about 20 different statuses. Users want the ability to select all values where the Intransit amount is a certain value while StillToBeCaptured is a certain value for example. Users should be able to select any value in any of the different stock statuses.&nbsp;The problem is that my initial table has the statuses and amounts going down.I was thinking of creating different measures for each but then there are slicers for measures. If I use a calculated column it taks it on the lowest level but I need it to be at the level of the rows.&nbsp;

greg_deckler · Answer

In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563

philseim · Answer

Thanks that's very useful. However in this case I need to select values so one column could be 0 and another column could be anything over 100. I need to do different combinations based on the column

Forum Discussion

Matrix filter on a column values

2 Replies

Related content

Matrix Column Widths

Matrix visual filter by column

Slicer for filtering several columns

Matrix column based on other matrix columns

Matrix column not grouped