Forum Discussion
Helper II created a visual type = Matrix in PowerBi. It's reading from a Microsoft List where the field typ
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
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
Helper IThanks 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. 😞
- 925stuart
Thanks Anonymous
Indeed I'm at Navigation.
- 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?