Forum Discussion

SBePicas's avatar
SBePicas
Regular Visitor
2 years ago

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                        ...
Need Help
trebgatte's avatar
trebgatte
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

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?