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 am anaylzing results from a survey which are pulled into power bi through a sharepoint list. The format of the sharepoint list is as follows:
I would like to graph the results on a stacked bar chart - yaxis being the questions and xaxis being the % answered of each type (Excellent, good, fair, poor, n/a), also being able to filter by project #, date, manager.
I believe the easiest way to do that would be to get my data in the following format:
How would I use power bi to transform the data this way? (Or is there a better way to format the data to get the resultant graph?)
Thanks so much!
Solved! Go to Solution.
In query editor, select Q1, Q2, Q3 columns, right click, and click 'Unpivot Only Selected Columns':
In query editor, select Q1, Q2, Q3 columns, right click, and click 'Unpivot Only Selected Columns':
When selecting unpivot only selected columns, all the columns display "error".
The error message is:
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://mytentnat.sharepoint.com/sites/qa/_api/Web/Lists(guid'542c4b4b-f41d-472b-a401-8e0768adc2d8')...
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |