I have a column with the following data
| fork & spoon
I would like to add a slicer to my page that has two options: Spoon, fork. When Spoon is selected it shows the result for the rows for Spoon and fork & spoon. When Fork is selected it shows the result for the rows for Fork and fork & spoon
Can this be achieved in powerbi?
If not directly, I was thinking that formatting my data like this could help perhaps? Does powerBI have an option to see values divided by semicolons as multiple values?
| Fork ; Spoon
EDIT: Bit more info on my actual table layout:
| Service A | revenue | category 1
| Service B | revenue | category 2
| Service C | revenue | category 1 & 2