Skip to main content
cancel
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.

Reply
SBePicas
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

                                                                                         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

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

How did you create a card with multiple columns?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

Announcements
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

PBI_APRIL_CAROUSEL1

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