How to find multiple string search at a time in power bi report to fitl

[alianjum123456]

I have a sentence in each line of records, I want to search multiple string at a time in power bi report, if one string match then the complete sentence I can able to display in report, but I want to search multiple string at a time.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[alianjum123456]

Here is the sample attached, i want to search 3 keywords like -- round, majestic & fly at a time and the result will be Aussie Round, Majestic Beaut & Tri Fly, 

I must search the multiple strings by separating the reach string using a comma or slash. 

This screenshot is the data that I have 

The screenshot below is the result I want, 

[lbendlin · Accepted solution]

i want to search 3 keywords like -- round, majestic & fly at a time 

Which visual would you want to use for that?  Advanced filtering only allows up to two items at a time.

[alianjum123456]

I want to filter more than 10 keywords at a time, is there any other solution than advance filtering 

[lbendlin]

There was once a free "Filter by List"  custom visual but I think they went commercial. 

Once you have figured out which (free) visual you want to use for entering the search terms  you can ping me again.

This might also be a good test for using CoPilot if that is enabled for your tenant and workspace.