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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

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
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.