Sharepoint List - Displaying multiple users in table visualization

[rikkijp]

I have my powerbi linked to a list in SharePoint. One of my SharePoint columns is a Person field that can have more than one person attached to it. When I expand it in PowerBI, how can I then display it in a table visualization by project without it creating multiple entries?

It is laying out like this:

Project 1   Resource 1

Project 1   Resource 2

Project 1   Resource 3

Project 1   Resource 4

Project 2   Resource 1

Project 2   Resource 2

Project 3   Resource 1

Project 3  Resource 2

I would like it to look like this:

Project 1   Resource 1, Resource 2, Resource 3, Resource 4

Project 2   Resource 1, Resource 2

Project 3   Resource 1, Resource 2

[v-chuncz-msft]

@rikkijp,

You may add a measure as shown below.

Measure =
CONCATENATEX ( Table1, Table1[Column2], ", " )

[rikkijp]

Thank you for your suggestion. When I tried this:

Resources = CONCATENATEX(PACEMasterProjectList,PACEMasterProjectList[ResourceAssigned],"; ")

List went from this:

to this:

[v-chuncz-msft]

@rikkijp,

Make sure it is a measure, not calculated column.