Text filter

[Khadim_BA]

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 ''Smithers''?

[Sug19]

You can utilize the slicer with search functionality for easier navigation and filtering. Selecting "Test" will give you only Test surname results.

[Anonymous · Accepted solution]

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]

I'm assuming you have tried this but you can click on the elipses and select "Search".