cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LaurindaS
New Member

Search In Different Order

I'm looking to have a search field that looks in a table where it searches the same words, but the words could be in a different order. In excel, it would be similar to the contains and contains filter instead of the exact filter.

 

Example

Description Field: Pen Blue Medium Bic

 

In the search field if "blue pen" is entered I would like for this description to come up. It's only coming up if I type the words in the exact same order. Eg. "Pen blue", "blue medium" & "medium bic"

 

Thanks in advance for your help! 🙂

Laurinda

2 REPLIES 2
goncalogeraldes
Super User
Super User

PBI has a functionality called "Synonyms" that may help you in this case! Please check the below link as it may provide some insights onto your problem:

 

https://www.biinsight.com/power-bi-synonyms-take-qa-experience-to-the-next-level/

 

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes

Hi Goncalo,

    This is our "work around" solution we have right now, but it's quite time consuming & leaves room for human error if I forget to add a variation,. There are thousands of fields in this table & some of the fields have alot of words in the description so I would have to put every variation that they might search to have it come up.

Example:

Description: Pen Blue Medium Point Bic Round Ballpoint

 

I would have to put every variation that they could potentially search.
Eg. Blue Pen

Medium Blue

Bic Pen

Bic Ballpoint

Ect.

 

I was hoping to find a way to have it search for all words in any order somehow in the programming so it doesn't allow for human error & more efficient.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors