How to filter across multiple columns with the same content

[AutismRunner296]

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

[AutismRunner296]

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

[Anonymous · Accepted solution]

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.

[Idrissshatila]

Hello @AutismRunner296,

did you try combining columns into one and use it https://zebrabi.com/how-to-combine-two-columns-in-power-bi/