Forum Discussion
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...
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 ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
I'm assuming you have tried this but you can click on the elipses and select "Search".