Multiple KeyWords

[kandre123]

Hi, I have a sector column with text keywords related to company a-> z such as SaaS, PaaS, CCaaS, Animal Husbandry and so on. Company a could have in this column only SaaS while company C could have SaaS, E-commerce, IT-Services. Separation of key words is with , I would like to have a search box to write for instance SaaS and it would find both company a and C. Crunchbase have a nice solution for this

In Power BI i found a tile searcher, but the search dont hit single keywords it just returns whatever is in the column. 

In here there is one company with Buildingmaterials and TMT. I just want the tiles to return single keywords

Edit:

Excel File https://www.dropbox.com/s/4ccyfx3uowfrne3/test.xlsx?dl=0

Pbix File: https://www.dropbox.com/s/a4wkl4ficr78d9b/1.pbix?dl=0

[mwegener]

Hi @kandre123 ,

do you know OKVIZ's Smart Filter Visual?

https://okviz.com/smart-filter/

[kandre123]

Yes, i've tried it. Same problem

[mwegener]

Hi @kandre123 ,

take a look at the attached solution.

[TomMartens]

Hey @kandre123 ,

please consider to create a pbix file that contains sample data and reflects your data model. Upload the file to onedrive or dropbox and shahre the link. If you are using Excel to create the sample data, share the xlsx as well.

Regards,

Tom