Forum Discussion
Filter table column on multiple conditions using slicer
Hi powerbisach,
After research, please create a new table including distinct all values from four columns. You can get a result which is similar with but not the same. Please see the result shown in the following screenshot.
Please download the .pbix file(attachment) for more details.
Best Regards,
Angelia
Any workaround to acheive the expected result..Any other approach/solution.
Thanks in advance
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.