Forum Discussion

925stuart's avatar
925stuart
Icon for Helper I rankHelper I
2 years ago
Solved

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

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
    Anonymous
    2 years ago

    Hi 925stuart ,

     

    You could get the column in the Navigation step

    Best Regards,

    Bof

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi 925stuart ,

 

You could get the column in the Navigation step

Best Regards,

Bof

 

925stuart's avatar
925stuart
Icon for Helper I rankHelper I
2 years ago

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?