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.
Rufyda Thanks for your reply!
Do I need to make a new reference table first? (or directly start with "duplicate the column in the fact table?)
I probably should have mentioned, that in the fact table there are other columns as well.
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.