Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Multi Person Select Column
03-19-2024
12:25 PM
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.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024
09:20 AM

Had to revert back to the 'FieldValuesAsText' column and have the 'Requestee' checked which then displayed the users assigned to that field.
6 REPLIES 6
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024
09:20 AM

Had to revert back to the 'FieldValuesAsText' column and have the 'Requestee' checked which then displayed the users assigned to that field.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024
09:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-19-2024
11:30 PM

Hi @keithfrb ,
Try to click on button of the data and you will able to expand the table information.

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
05-11-2024 12:02 AM | |||
07-25-2024 05:45 AM | |||
04-17-2024 08:28 AM | |||
07-04-2024 06:34 AM | |||
12-20-2023 04:21 AM |