Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Regular Visitor

Find word in multiple columns

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




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

Super User
Super User


How did you create a card with multiple columns?

Ashish Mathur

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?

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors