Visual for filtering data with multiple keywords

[tanehome1]

Hi All

I need a visual where users can write multiple keywords to filter data. In my case, I would need to filter with AND operation, meaning that all rows that include any of the keywords are shown.

I have tried Microsoft's Text Filter visual. That visual does not searching with multiple keywords.

appriciate your assistance.

[tanehome1]

thank you for reply, sorry for my mistake as i need to search the multiple words with "AND" not "OR" and i write "OR" by mistake

actually new text slicer is great but it seems it using "OR" and no option to change it.

is there a way to change it to search with "AND"?

[lbendlin]

It's allegedly on their roadmap for future features.

Use the Advanced Filter in the filter pane if you want to do this now. You can have more than two conditions there too.

[tanehome1]

thank you for reply and for good news that it will be available in the future, hope will be soon.

actually, i did not prefer advanced filter and tring to find more user freindly way to do so.

[lbendlin]

I think we have differing opinions on what "user friendly"  means.  Make sure to test with your real world users.

[suparnababu8]

Hi @tanehome1 

I agree with @lbendlin  comments. You can use new Text slicer as it's a default vaisual.  Please follow below steps.

1. Let's say you have to search the key words like "Book, Pencils and White" Refer below snapshot 
2. Now I will search those key words in text slicer. You will be able to see all values related to these key words will be filtered as shown in below snapshot.
3. 
4. So if you want to search multiple values you have to turn on one option under formatting settings is Accept Multiple Values under slicer settings. Pls refere below snapshot 
5. 

Additional Tip: Still it's in preview stage. So, Don't use this in your Production environments until and unless it has GA announcemnet.

I hope now you are clear.

Thank you!Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

[lbendlin]

Try the NEW text slicer. It actually does that. Sort of.

Introducing the new text slicer in Power BI - Microsoft Fabric Community