Forum Discussion

rikkijp's avatar
rikkijp
Frequent Visitor
8 years ago

Sharepoint List - Displaying multiple users in table visualization

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...
rikkijp's avatar
rikkijp
Frequent Visitor
8 years ago

Thank you for your suggestion. When I tried this:

 

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

 

List went from this:

 

to this:

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

rikkijp,

 

Make sure it is a measure, not calculated column.