Forum Discussion
Filter on multiple contains in a single search string
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?
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.
9 Replies
- Tutu_in_YYC
Super User
Try 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.
