How to filter on comma separated column

[sa000]

Hi.

Suppose I have sample data as this

Product	Color
A	red
B	red
C	blue
D	red,blue
E	red,blue
F	blue
G	blue

I would like the user to be able to filter by the color, red OR blue, not "red, blue". So if the user selects Red, A,B,D,E are filtered. Right now I'm not sure how to create a filter to do that. 

I see a similiar post which looks like it accomplishes what I want but is a bit hard to follow, https://community.fabric.microsoft.com/t5/Developer/Filter-on-comma-separated-multiselect-field/m-p/...

[Ashish_Mathur]

Hi,

In the Query Editor, split the colour column by rows using the comma delimiter.  Click on Close and Apply.  Now create slicer/visuals.

[sa000]

This is great! Can you outline your steps so I can reproduce in my usecase?

[Ahmedx]

to know how to do this watch my video

https://1drv.ms/v/s!AiUZ0Ws7G26RjVdgrQApbiyC-hcE?e=Ncv57v

[sa000]

Thank you! This almost works except I can't do multi selection without an error? Is there a way to accomplish this

[Ahmedx]

pls try this code

[Ahmedx · Accepted solution]

pls try this