Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • HotChilli's avatar
    HotChilli
    Community 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.

  • Icey's avatar
    Icey
    Community Support

    Hi Anonymous ,

     

    Try to use a slicer to filter "Yes" or "No".

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.