Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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.



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! 🙂


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:


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 👍

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.


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



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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors