I created a visual type = Matrix in PowerBi. It's reading from a Microsoft List where the field typ

[925stuart]

Hi,

I created a visual type = Matrix in PowerBi.  It's reading from a Microsoft List where the field type = Person or Group.  When I'm displaying it in the Matrix, it shows as IDs instead of the name/string of the Person or Group.  I'm sure there is a trick here, pray tell.  🙂

[Anonymous · Accepted solution]

Hi @925stuart ,

@audreygerred , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:

1\Edit Query

2\Find the person column and then expand this column(Email/Title)

3\ Result

Before

After

Best Regards,

Bof

[Anonymous · Accepted solution]

Hi @925stuart ,

@audreygerred , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:

1\Edit Query

2\Find the person column and then expand this column(Email/Title)

3\ Result

Before

After

Best Regards,

Bof

[925stuart]

Thanks @Anonymous !  Your post gave me a lot of clues!  However, I see that when you read the list, the field was read as type = record.  

However, in my case, it was read as type = text.  I tried to transform it to record but did not have the option.  😞

[Anonymous · Accepted solution]

Hi @925stuart ,

You could get the column in the Navigation step

Best Regards,

Bof

[925stuart]

Hi @Anonymous ,

Thank you very much for your advice, I found what I was doing wrong.  

However, I'm now struggling with extracting the data out from Table - e.g. when there are 2 or more Persons in the field.  I saw we could break each Person into its own line but is that the only way?  Is there a way to avoid splitting each Person into its own line but instead use a separator between each person?

[925stuart]

Thanks @Anonymous 

Indeed I'm at Navigation.

[audreygerred]

Hi! I think that in the list the name field actually comes from a lookup so Power BI will initially dispaly the ID. In Power Query, on the field that is Person or Group, does it contain Record? If so, click to expand it then select the fields you want (like name, email, etc).

[925stuart]

After PowerBi reads the List, 2 fields were found in Power Query.  1 is simply the field name TeamLeader, the other is TeamLeaderstringId.  Both are Text.  However, when displayed in a visual - they are numeric.