How to make a slicer in Power BI behave as filter in Excel - filter by typing beginning of a string

[KaterinaB]

We have a slicer with many values, Select all and Search functions. When user selects all first (because otherwise "select all" disappears) and then starts typing in Search box, the slicer will select the values that contain the typed string, but it will not actually filter the data on the page.
Example - slicer for countries - first we click Select all and afterwards "b" -> all countries containing b get selected

But there is no "filter" button to filter the page by these multiple values, as we can do in Excel

Is there a way of achieving similar behaviour in Power BI?
The actual use case is a slicer with thousands of product codes that could be filtered by searching a part of the product code and this way filtering the page/report on the dozens of products that contain the searched string. Selecting each code one by one is very tedious
Thanks a lot!

[_AAndrade · Accepted solution]

Hi @KaterinaB,

Take a look at this example:

Like I said in my first post, I'm using TextFilter visual from the store and I think is doing what you're looking for.
You can text the letter and then press enter or doing what I did in the gif.

[dharmendars007]

Hello @KaterinaB , 

You can create search option to your filter/slicer in powerbi , please select the filter visual and press Ctrl+F this will create a serach option inside slicer button..

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[KaterinaB]

Thanks for the reply. We already have a search function in the slicer. The issue, we dont want to select every single value returned by search, because in our case this might be dozens of rows to select
That's why we tried with Select all first and then searching, however this doesn't filter 

[_AAndrade]

Hi @KaterinaB,

Please try to use Text Filter visual from the store. It can do what you're looking for.

[KaterinaB]

Thank you for the tip, it might work as a workaround together with the normal slicer, although not sure how users will feel about two slicers for the same. Since it doesnt have any dropdown or list, I cannot see the actual selection I am making, is there any way around it?
Also it seems, that I cannot apply "Clear all slicers" on it.

[_AAndrade]

You only need one slice to do this and if you have another slicers you can create a bookmark to clear all filters and It will work like the clear filters option that we have nowsdays.