Slicer on PowerBI

[Anonymous]

Hi,

I am looking for a Slicer where I need to add the Search button without clicking more options as well as if I select a value, I want the data to get filtered out based on the pre-selected value just like the way it works in excel. Please let me know which visual I can use if not on Slicer.

For Ex: I have a field called Test having the list of values as 123, 256, 289,345,970

If I search 2, then it should pre-select all the values having 2 in it then show the data.

Thanks,

Snow

[Andreas-Harlak]

Hi @Anonymous ,

you could also use the normal Power BI Slicer for your desired procedure.

However, the data must be in text format, you can search for texts or numbers that you first convert into a text format in Power Query. Here you then determine whether it should be multiple selections or single selections.

I hope this will helps you, a "Like" would be great 🙂

[Kedar_Pande]

@Anonymous 

Use a Custom Visual (e.g., Smart Filter Pro)

Smart Filter Pro provides:
A search box with an automatic selection feature.
Automatic data filtering as soon as matching values are found.

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[Uzi2019]

Hi @Anonymous 

Try Text Filter. it works well with text/numeric  input.

and its free you dont need to purchase any further license.

other option is text search slicer

it is also free.

I hope I answered your question!

[Anonymous]

Hello,

None of the solutions are working. I want to implement the exact same way we have on excel. If I search a value and enter, it will select the values then show the result.

Thanks,

Pbisnow

[Anonymous]

Thanks for the reply from Tutu_in_YYC , please allow me to provide another insight: 
Hi  @Anonymous ,

Here are the steps you can follow：

If your table data contains only integer type data, you can use Parameters to create a 0-9 table with no join relationship as a slicer, and use CONTAINSROW() to determine whether the selected finger in the slicer is in the data:

Modeling – New Parameter – Numeric range

Create measure.

Flag =
IF(
    CONTAINSSTRING(
        MAX('NumberTable'[Number]),[Parameter Value])=TRUE(),1,0)

Place [Flag]in Filters, set is=1, apply filter.

If your data inside is text type, you can use custom visual - Text search slicer, this visual can fuzzy match the search box information.

Click on the three ellipses - Get more visuals -- Text Search Slicer

When slicer selects A, it displays the data containing A

Best Regards,

Liu Yang

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

[Tutu_in_YYC]

Try this slicer from OkViz. It should do what you want.

https://okviz.com/smart-filter/