Filter on multiple contains in a single search string

[MartinDawson]

I'm a complete noob at PowerBI and I need some help understanding if this is even possible.

There is a filter set up for the Name column here, but it's difficult to use since you can only search by a single contiguous phrase at a time.

I'd like to be able to search using what I'd call "search engine style", where each individual word of the search term is a separate "contains" clause -- so for example you could search for "steel casing 10" and successfully find "10 inch Casing Pipe - Steel, Open Cut".

Is that possible? If so, how complicated would it be to set up?

[Tutu_in_YYC]

Try switching to Advanced Filtering and use the "Contains" option.

[MartinDawson]

That doesn't seem to do anything, at least not yet. It won't let me Apply filter without providing a search term in the second input.
This is supposed to be a user-searchable control. That's how it was working under basic filtering. How do I tell it to use the contents of the search box here?

(I'm afraid this is going to be a bit of an "explain it to me like I'm 5" situation.)

[Tutu_in_YYC]

ah, it is for user.. Then use a slicer.

[MartinDawson]

Maybe I'm using the wrong words... this list IS a slicer for the rest of the page. I want the Search function to work differently. Using your example, I would want to be able to use "click be" to find the first option. How do I use a slicer to do that?

[Tutu_in_YYC]

Just to clarify, because in power bi, there could be some terms that are ambigous.

Yellow is a slicer, with field using a column called Definition. Slicer is a visual that you pick from the visualization pane. Blue is a filter. You can find them in the filters pane.

They both "filters" data, with a slightly different way in power bi desktop.

I re-read your challenge, and if i understand correctly, based on the example i have, you want to search "Click" and "Be", and it should return "A click will be registered..." and any other items that has "click" and "be" in it.

I have looked at other custom visual slicers options, but havent found one that does that. The only option right now is to use the filter pane, as below example:

[Tutu_in_YYC]

And here is a tutorial, if you want to have more than 2 (as shown in previous reply). Its a bit of a workaround.

https://youtu.be/aojcHUsOeyM?si=XvS1KLv6ATuwaZHo&t=104

[MartinDawson]

Okay, I appreciate the tutorial.

Unfortunately I don't want to permanently filter the slicer by "click" and "be", but rather allow the user to type "click be" in the Search bar for the slicer and have it narrow the slicer options down to all options that contain both "click" and "be". (Or whatever set of search terms they may type in, very possibly exceeding 2 words.) It sounds like that is not possible.

[Tutu_in_YYC · Accepted solution]

Yeah doesnt look like it is possible yet. There are a few custom visuals on the marketplace, I have tested probably about 5 of them, and none can do what you want unfortunately.

[MartinDawson]

All right. Thank you very much!