Multiple People-column choices from SharePoint list to Power BI

[Anonymous]

Hi! I have a SharePoint list with a 'Person or Group' column that may have selections from 1 to 10 people. When I import the list into Power BI, columns such as 'AuditorsID' and 'FieldValuesAsText' are included, which contain information from that column. My goal is to create a chart that shows how many times each person is mentioned in the SharePoint list data, which describes amount of safety inspections.

In this case there are 3 persons in the column but there may be up to 10 in some cases.

I'm pretty new with PowerBI so I would like to have step by step instructions if possible!

[christinepayton]

I have a tutorial on working with SharePoint list data that includes a section on multivalue person-type columns. Here's a link directly to the person column bit: https://www.youtube.com/watch?v=LYu3wqb2Nx4&t=394s

[Anonymous]

Hi @Anonymous ,

First of all, I think you can export to Power BI.

Then you can create a measure to calculate rows.

Measure = COUNTROWS('Table')

Finally you can use card visual and you can get what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello and thanks for your help @Anonymous !

For some reason the Auditors column is empty when I import the data to PowerBI...

[Anonymous]

Hi @Anonymous ，

Sometimes this problem does occur and I think it may be related to refreshing.

Of course if you retry and find that it still doesn't work, I think you could try importing the data into an Excel sheet first and then into Power BI via Excel.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.