Keyword search in power Bi

[akj2784]

Hi All,

I have a requirement where I want to have a keyword search slicer so that user can type multiple keywords and it should filter the report whereever those keywords are present in the description text column.

Consider the example of keyword search in the twitter data.

I have tried Smart filter, Attribute Slicer but those are actually showing the data present in the text column what I place in the slicer. I dont want that to show the text in the slicer. It should only accept the keyword from user and automatically filter on a column.

Regards,

Akash

[rocky09]

Use Text Search Visual. But, It only works with Single Column.

You may concatenate all the Columns and make a custom column then Use that Custom Column for the Search.

[akj2784]

I tried that but how do I search mutliple keywords here. I have only one column to search. But in that I want to give flexibility so that user can search multiple keywords. I tried giving , ; OR AND but nothing worked.

[rocky09]

Yes..

Check this thread..

https://powerusers.microsoft.com/t5/Using-PowerApps/Search-with-multiple-words-in-multiple-columns/t...

[v-yuta-msft]

Hi rocky09,

So you requirement is to achieve a filtered visual with multikey words, right? You may try Q&A feature in power bi desktop and check if it can meet your requirement.

Regards,

Jimmy Tao

[akj2784]

That needs power apps to be implemented. The text filter works fine for me in terms of functionality but its just that it does not allow multiple keywords search.