Have column with multiple values in powerBI, for use with a slicer

[cmplieger]

I have a column with the following data

|  spoon
|  fork
|  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 semicollons as multiple values?

|  Spoon
|  Fork
|  Fork ; Spoon

Thanks!

[v-shex-msft]

Hi @cmplieger,

>>Can this be achieved in powerbi?
Currently, slicer not support this feature.

>>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 semicollons as multiple values?
It also not support, current power slicer not support wildcard and regular expression. If you format the values add "Fork ; Spoon" to source and selected, slicer will try to filter the records which column value is "Fork ; Spoon".

I'd like to suggest you post these requirement to ideas.(BTW,I'm still not understand why you want to operate like this )

Regards,

Xiaoxin Sheng

[cmplieger · Accepted solution]

There are actually solutions:

http://stackoverflow.com/questions/42404400/have-column-with-multiple-values-in-powerbi-for-use-with...

[Phil_Seamark]

Have a good play with the Query Editor. 

You'll be able to split your column based on a delimter and then do some more massaging to get the extra values back into a single column.

[cmplieger]

Splitting them and reuniting them in a different fashion is easy. however I am not sure how to work out the solution to the end where the slicer shows the appropriate rows. Can you explain a bit more in depth what you meant?