Forum Discussion
Filter on multiple contains in a single search string
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.
Super Userah, it is for user.. Then use a slicer.
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=104Okay, 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.