Power BI/Query: How to Show Multi-Value Column as Single Row and Filter on Individual Items?

Hi everyone,

I’m pulling data from a Microsoft List into Power BI. One of the columns contains multiple values (like a collection of tags or items), and Power BI is creating a separate row for each of those values—so I end up with a lot of duplicate rows. From MS Lists:

What I’ve tried:

1. Extract to new column with line breaks:

In Power Query, I extracted the values to a new column and separated them using “Replace Values” to put each value on a new line. This keeps one row per person, but on the dashboard, Power BI concatenates all the values together, so I can’t filter on individual items. Here’s how it looks in the dashboard, slicer, etc:

2. Extract to new rows:

I also tried expanding the list into new rows in Power Query. This lets me filter by individual tags, but then each person appears multiple times—once for each value in the multi-value column—which throws off totals and counts.

What I need:

1. Each person (record) should appear only once in the dashboard.
2. I want to be able to filter on individual tags/items from the multi-value column.
3. Ideally, the multi-value column is shown as a semicolon-delimited string (e.g., “Item A; Item B; Item C”) but still filterable by individual tags.

Has anyone solved this? Is there a way to transform or model the data so I can both keep unique rows and filter on individual items?

Thanks in advance!