Forum Discussion

Khadim_BA's avatar
Khadim_BA
Regular Visitor
2 years ago
Solved

Text filter

Is there a way to search for names using Power BI's text filter or another way, so that if you search for, say, "Smith", only the names "Smith" will appear, and no names like ''Smithson'' or ''Smithe...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Khadim_BA ,

     

    I can provide you with a workaround that gets the subject name first and then filters it using a slicer. I have created simple samples and you can check the results as below:

    In Power Query, you can use column From Example to get the primary name:

    Drag the fetched fields into the slicer after application:

     

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Khadim_BA ,

 

I can provide you with a workaround that gets the subject name first and then filters it using a slicer. I have created simple samples and you can check the results as below:

In Power Query, you can use column From Example to get the primary name:

Drag the fetched fields into the slicer after application:

 

 

An attachment for your reference. Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.