Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
gmdls
New Member

Match whole words in Text Filter

Hello everyone,

 

I'm using the Text Filter feature from the Market Place to make text searches in a table with projects information. 

 

My goal is to filter my projects by machine by filtering the description column where this information is stored. 

 

However, I have the following problem: whenever I type "palletiser", the filter also matches with all columns that have "depalletiser" in them. 

 

I would like to config this text filter to find only whole words to avoid this kind of situation. 

 

Is it possible?

 

Thanks in advance. 

1 ACCEPTED SOLUTION

Hello, 

 

I solved the problem by filtering the data in Excel before importing to Power BI

 

Thanks

View solution in original post

2 REPLIES 2
Hardik
Continued Contributor
Continued Contributor

Hi  @gmdls,

 

Can please share some references and images to better understand you query.

 

a sample data could work too.

 

Thanks,

 

Hardik

Hello, 

 

I solved the problem by filtering the data in Excel before importing to Power BI

 

Thanks

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.