Forum Discussion
Multiple variables on x axis? Stacked column visualization
I have data that is from a SharePoint list that is similar to a test you would take. Columns are Name, Test Date and then another 30 columns that are the test questions. Each test question column c...
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
In Query Editor mode, please unpivot table to convert its structure to below format.
Place [Questions] onto X-axis and place [Answer] into legend of a stacked column chart.
Best regards,
Yuliana Gu
That looks good
I'll have to research this more as when I just unpivoted one column, my entire table is now showing Error for the values
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.