Slicer for Multiple-Choice Values

Hi, I have a fact table containing values from a website form where multiple choices are possible. My goal was to create a dimension table and use it as a slicer. However, it only works with exact ...

Need Help

v-hashadapu
9 months ago
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.

v-hashadapu

Community Support

9 months ago

Hi cn4422 , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.