Filter table column on multiple conditions using slicer

One workaround I can think of is to "unpivot" the table, so that all the values you want to search are in the same column :

(1) add an identifier column to each row (so that you can tell which row/s contain a match)

(2) unpivot all the columns you want to search

(3) add a slicer on the "Value" column

The original table you had was like this:

Column1  Column2  Column3  Column4

  a                b               c               s

  b                a               a               y

  d                a               b              c

  g                c                c              d

And the new table should look like this:

RowID      Column    Value

row1         Column1      a

row1         Column2      b

row1         Column3      c

row1         Column4      s

row2         Column1      b

row2         Column2      a

row2         Column3      a

row2         Column4      y

row3         Column1      d

row3         Column2      a

row3         Column3      b

row3         Column4      c

row4         Column1      g

row4         Column2      c

row4         Column3      c

row4         Column4      d

If you put a slicer on the Value column, you will be able to find out which row and which column contains a match.  The output won't be in the form of your original rows, but it's a workaround that will support searching.

Hi powerbisach,

If my solution is acceptable, please mark it as right answer, so that more members like you will find workaround easily.

Thanks,
Angelia