Forum Discussion
How to filter across multiple columns with the same content
Couldn't find anything by searching, so trying my luck here.
I have a spreadsheet (from JIRA) that contains 3 columns called Label, Label1, and Label2. They can all contain exactly the same entries. Is it possible to combine the 3 into 1 filter, so if I wanted to search for the "Apple" in any of the 3 columns, it brings back the corresponding row.
Thanks all in advance
Hi,
Thanks for the solution Idrissshatila provided and i want to offer some more information for user to refer to.
hello AutismRunner296 , you can refer to the follwing sample.
Sample data
Slicer table
Then create a measure
Measure = COUNTROWS(FILTER(Slicer,CONTAINSSTRING(MAX('Table'[Value]),[Type])))Put the measure to the visual filter.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- Idrissshatila
Super User
Hello AutismRunner296,
did you try combining columns into one and use it https://zebrabi.com/how-to-combine-two-columns-in-power-bi/
How would I then filter on the merged columns, for example I could have:
Apple, Orange, Banana
Banana, Apple, Kiwi
If I wanted to filter on Banana how would I go about it
Hi,
Thanks for the solution Idrissshatila provided and i want to offer some more information for user to refer to.
hello AutismRunner296 , you can refer to the follwing sample.
Sample data
Slicer table
Then create a measure
Measure = COUNTROWS(FILTER(Slicer,CONTAINSSTRING(MAX('Table'[Value]),[Type])))Put the measure to the visual filter.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
