Find word in multiple columns

[SBePicas]

I have a card with multiple columns similar to this:

ColumnA             Column B             Column C     Column D

Red                        Red                        Red                        Red

Blue                       Blue                       Yellow                   Yellow

Green                    Green                    Green                    Brown

                                                                                         White

                                                                                         Purple

I need to create a custom filter (script) that search for all columns containing specified text

For example, if I search for Green (Column A, B and C shows they have the word, likewise searching for Brown, Only Column D will show.

Any help is greatly appreciated

[Ashish_Mathur]

Hi,

How did you create a card with multiple columns?

[trebgatte]

Seems like you'd have to create a merged column in Power Query with a delimiter as your search column. In the Power Query editor, ctrl + click the columns, go to the Add Column tab in the ribbon and select Merge Columns. Pick a delimiter and click OK. 

Are you doing a Text search with a custom visual or are you planning to use a slicer?