Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Delphia
Advocate II
Advocate II

Slicer values that are in the list

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!

1 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.

mussaenda_0-1637245331770.png

 

View solution in original post

4 REPLIES 4
mussaenda
Super User
Super User

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.

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.

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.

mussaenda_0-1637245331770.png

 

Great! Thank you so much!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.