Forum Discussion
Slicer for Multiple-Choice Values
Hi cn4422 , Thank you for reaching out to the Microsoft Community Forum.
You don’t need to split the main fact table directly. Instead, create a reference table from it in Power Query, keep only the record ID and the multi-choice column. Then split that column by commas into rows, so each choice becomes its own row. This new table acts as a bridge between your fact table and the dimension table (link ID -> fact and choice value -> dimension). Now your slicer from the dimension table will correctly filter all rows that contain the selected value, even when it’s part of a comma-separated list.
here is a workaround for you,
create a duplicated column for fact table and split by comma to rows.
then create a measure and add that measure to visual filter and set to 1.
Pls see the attahment below
HI ryan_mayu ,
thanks for your reply!
In the fact table, there are other columns as well - isn't this problematic if they all get additonal rows?
I probably should have mentioned, that in the fact table there are other columns as well.
cn4422 I am not sure if other columns will affect this solution or not. Depends on what's the expected output that you want. Pls update the sample data and expected output.
