Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm pretty new to Power BI.
I have created a project status dashboard in Power BI Desktop. My data is being pulled from a Sharepoint online list.
My online list columns are as follows:
Country | Vertical | Categories | Project Title | Project Stage | IT Owner | Status
The IT Owner column is an AD lookup field so as to easily enter a person's name.
On my dashboard, I have a stacked column chart visualization for Project Status by IT Owner.
In some cases, there might be several IT Owners for the same project.
I have attached two screenshots for example:
For the above example, the visualization treats the same IT owner (Bino Balan) as two different values. How can I pull distinct names from a group of IT owners in this example and add the status count to their individual names?
Thanks!
For a project including 3 people i'd say you need to create 2 additional rows. This can be done by a combination of split column and unpivot:
Highlight your new columns and then press unpivot.
You should get a row for each participant in each project.
I was able to split the columns but unpivoting the new columns caused the new columns to disappear and the following error:
DataSource.Error: We couldn't parse OData response result. Error: A value without a type name was found and no expected type is available. When the model is specified, each value in the payload must have a type which can be either specified in the payload, explicitly by the caller or implicitly inferred from the parent value.
Details:
DataSourceKind=SharePoint
DataSourcePath=https://#######/sites/it
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |