Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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/...
Solved! Go to Solution.
Hi,
In the Query Editor, split the colour column by rows using the comma delimiter. Click on Close and Apply. Now create slicer/visuals.
This is great! Can you outline your steps so I can reproduce in my usecase?
to know how to do this watch my video
Thank you! This almost works except I can't do multi selection without an error? Is there a way to accomplish this
User | Count |
---|---|
93 | |
86 | |
68 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |