Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
SarahEldurini
New Member

Problem with data retrieval

Dears,

 

I am new to PBI, and I have a problem with my report as below:

I am using PBI Desktop

my original sharepoint list has multiple columns, one of which is named: "Assigned to". The column type is "People or Group"

SarahEldurini_2-1689242464223.png

 

Where we may choose one user or multiple users as in the screenshot below, but the user names are not typed manually, they aree taken from onrganization userslist

SarahEldurini_0-1689242283691.png

 

but on Power BI, the report shows the column data as one data point called: List as in the screenshot below

SarahEldurini_1-1689242365460.png

 

and the report chart shows only one column!

SarahEldurini_3-1689242630508.png

 

How can I fix this so that it shows the x-axis as the assigned to users?

 

 

1 REPLY 1
lbendlin
Super User
Super User

Read about "User Information List" and how to expand lists to new rows in Power Query.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.