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 UserTry switching to Advanced Filtering and use the "Contains" option.
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.
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: