Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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"
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
but on Power BI, the report shows the column data as one data point called: List as in the screenshot below
and the report chart shows only one column!
How can I fix this so that it shows the x-axis as the assigned to users?
Read about "User Information List" and how to expand lists to new rows in Power Query.