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...
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

rikkijp,

 

You may add a measure as shown below.

Measure =
CONCATENATEX ( Table1, Table1[Column2], ", " )
  • 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.