Forum Discussion
Data Modelling for Likert Scale from Sharepoint Survey Import
Hi everyone! I have the following problem: My data source is a sharepoint survey that includes likert scales. In the initial table I get in Power BI, all the answers from the likert scale are...
AllisonKennedy
Community Champion
Community ChampionYou have the right idea - i recommend doing this in a separate table, so right click on the query in the left hand side and reference the 'raw data' query.
Then click the double arrow at the column heading for the likert scale question to expand the parameter and answer columns from the list of records.
Finally, select the two new columns and Pivot them (put the answer as values, and choose don't aggregate under advanced options).
Hope that all makes sense?
Then click the double arrow at the column heading for the likert scale question to expand the parameter and answer columns from the list of records.
Finally, select the two new columns and Pivot them (put the answer as values, and choose don't aggregate under advanced options).
Hope that all makes sense?