Forum Discussion
How to filter multiple columns
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).
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! 🤠
1 Reply
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! 🤠