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 nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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 | |
| 2 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 11 | |
| 5 | |
| 4 | |
| 4 |