Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
New to Power BI/Query.
How can I get this column to show the individual people? This is from a SP List that is using multi select person. I'd like to show Picture, FirstName, LastName, Department, JobTitle of the individuals assigned to this field.
Thanks in advance!
Solved! Go to Solution.
Had to revert back to the 'FieldValuesAsText' column and have the 'Requestee' checked which then displayed the users assigned to that field.
Had to revert back to the 'FieldValuesAsText' column and have the 'Requestee' checked which then displayed the users assigned to that field.
Hi @keithfrb ,
Try to click on button of the data and you will able to expand the table information.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 11 | |
| 4 | |
| 4 | |
| 4 |