Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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.
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.
Great! Thank you so much!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |