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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
rafa97cteep
Frequent Visitor

FILTER WITH IF AND CONTAINSSTRING

Hi guys,

 

i trying create a filter using a word/string contained in the analyzed cell, as in the image below:

rafa97cteep_1-1653487477690.png

 

For example, cells have several descriptions, such as "sanar", "defeito", "ninho".... would there be any way to use an IF with the CONTAINSSTRING to create a default filter to use the data segmentation

 

 

1 ACCEPTED SOLUTION
Nathaniel_C
Super User
Super User

Hi @rafa97cteep ,
Sure, go to Power Query, go to add Column, Conditional column and see my pic below.


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Nathaniel_C_0-1653501379802.png

Nathaniel_C_0-1653501606962.png

Nathaniel_C_1-1653501698130.png

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Nathaniel_C
Super User
Super User

Hi @rafa97cteep ,
Sure, go to Power Query, go to add Column, Conditional column and see my pic below.


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Nathaniel_C_0-1653501379802.png

Nathaniel_C_0-1653501606962.png

Nathaniel_C_1-1653501698130.png

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Nice @Nathaniel_C  😁 its work for me!!!!

 

Last question, this condition can distinguish if the same word is spelled differently? for example: house House hoUse

 

Because I wanted to ensure that this condition caught the word, regardless of how it is written

Hi @rafa97cteep ,

Good point.  Add a column that uses Text.Lower() -see picture- and point the previous column to that new column. This way no matter how they type it, it gets converted to lower case for the test.
Once again, please mark this as solved, so that other people who are looking for a solution can find it easier!


Thank you, and good luck!


Nathaniel

 

Nathaniel_C_0-1653505018333.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors