Forum Discussion
Can't edit visual filter
I am new to Power BI so any help would be appreciated.
I have created a matrix in the picture below with a series of criteria that have yes or no answers. I would like to filter out all rows that have 'No' as an answer however I cannot click within the filter panel at all.
2 Replies
- HotChilliCommunity Champion
Something is unusual about the matrix.
From the screenshot, the Rows and Columns wells are empty.
From the Visual Filter shown , it looks like CAFOD and Apostleship of the Sea are in the Values well of the matrix. These will have to be measures or aggregations but I can't see what they are because the 'Drill Down Groups' is not expanded in the screenshot.
You can't filter anything in a matrix unless there is a row or column to filter it by (as far as I remember).
So I think you'll need to reconsider what you are displaying.
If you want to post data (if it's not private) and tell us what your desired outcome is, we can help.