The Custom Visual Text Filter by Microsoft allows searching based on a phrase. If I type for example "video voice", it will search the input as a phrase not separate words.
Is there maybe a visual like a Text Search that can search based on several key words? Is there a visual with something like lucene syntaxe so I can search with "video + voice" ?
thank you for brainstorming 🙂
I think you could use something like:
Column = VAR __first = SEARCH("video",[Column],1,0) VAR __second = SEARCH("voice",[Column],1,0) RETURN IF(__first = 0 || __second = 0,"Not Found","Found")
Thank you for wuick reply, @Greg_Deckler.
The solution is a good for a custom column. However, I need a visual in a form of a search box, so users can search comments based on keywords they put in. Do you maybe have something on your mind?
You may try "Smart Filter by OKViz". It might not meet your requirement exactly, but users can type into multiple text one by one, and choose the item from drop down list.
It's a good idea, but it wont work in my case. The field that user are searching in contains customer feedback (very long sentences). But thank you for thinking through.
Unfortunately, I could not find any other proper visual that supports multi-word text search. You may need to submit an idea here.
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!