How to filter multiple columns

[sophtee]

Hello everyone,

I would like to filter multiple columns in a table in Power BI:

Example, if I select or search flock 414-2 it would show the 3 rows with the data, I not sure if there is something that can filter this data better than the slicer that I have. The filter would be for (Flock1, Flock2, Flock3, Flock4 and Flock5).

[Daniel29195 · Accepted solution]

@sophtee 

one approach you can, 

unpivot your table in power query, so that you will have , 

attribute column with values { floack1 , flock2, flock3, flock4, flock5 } 

and value column with all the values for the 5 columns into one column.

then you can use this column in your slicer.

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠