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.
Split the multi-choice column into rows in Power Query:
Duplicate the column.
Split by delimiter (comma) → Split into rows.
Use this new column in your slicer.
Use PATHCONTAINS() with a measure if you cannot split the column.
If this helps, please mark as Accepted Solution and drop a "Kudos"
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.
