Slicer values that are in the list

[Delphia]

Hi,

need your help with the slicer.

I have a matrix with a column "item", values in the format "list":

Item

pen

pen, pencil

pencil, scissors

pen, scissors

I should have a slicer item that will indicate unique values from the list of Items:

1. pen

2. pencil

3. scissors

When I choose "scissors", the result should be all lines that contain "scissors" in the list of Items:

Item

pencil, scissors

pen, scissors

Is it possible to do in PowerBI?

Thank you in advance!

[mussaenda]

Hi @Delphia ,

On the slicer, have you tried to enable your search option?

If you will search for scissors, it will show the items you searched.

Hope this helps.

[Delphia]

Hi, thank you!

It works, but then you should check all possible options and it can be 20 different combinations.

So, I wonder if there is any possibility to do it in another way.

[mussaenda · Accepted solution]

One more option is to add a custom visual text filter. once you search for scissors, it will automatically show aand filter you items with the word you searched.

[Delphia]

Great! Thank you so much!