Slicer on PowerBI

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

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!

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 🙂

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

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

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