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.
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.)
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=104