Fuzzy Search slicer

[pratichi]

I have a table for Responsible person as follows 

I would like to have a search slicer, wherein if I type for eg Sergey, All rows with Sergey should be selected. 
Is that possible in power BI? 

[amitchandak · Accepted solution]

@pratichi, there is a custom visual. I'm not sure it'll fit in --https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104381309?tab=overview

[pratichi]

Thanks Amit. It worked!!!

[pratichi]

@mussaenda @rajend12 I ve tried activating search function in the normal slider, but then it doesn't select and search for all possible cases. I have also tried Fuzzy look up but that would mean as task where 2 or more people are responsible, it would only pick one which is again not ideal. Would it be possible to do this as a measure?

[mussaenda]

@pratichi ,

The visual that Amit told you is the same custom visual I recommended to you.

Glad that helped!

[mussaenda]

Hi @pratichi,

There is a certified custom visual that suits your requirement

Hope this helps

[rajend12]

Hey @pratichi ,

You can have search option in the slicer. You can refer to the link below:

https://windowsreport.com/add-search-slicer-power-bi/#:~:text=Steps%20to%20add%20the%20search,find%2....

Hope this helps!!!!

Cheers!!!!!

[amitchandak]

@pratichi , Have you already tried

https://www.poweredsolutions.co/2019/03/26/fuzzy-matching-in-power-bi-power-query/

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-2018-feature-summary/#fuzzyMatchin...