cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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 in one cell as a 'List' (see screenshot). In the list is a record and in the record is the parameter (here: DevOps) and the selected value (here: 2).

 

I would like to create a new table in which ProjectName and the five parameters (DevOps, etc.) from the likert scale are columns and the values are rows, as shown in the excel screenshot below. ProjectName I would like to connect back to the table from the data source.

 

Can anyone tell me how to transform the data in way described above?

 

Thanks a lot in advance!

 

Best,

Jonas

2018-09-30_15h23_57.png

 

 

2018-09-30_15h36_42.png

 

1 REPLY 1
Highlighted
Super User IV
Super User IV

Re: Data Modelling for Likert Scale from Sharepoint Survey Import

You 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?

 


______________


Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 


If you found this post helpful, please give Kudos.


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


excelwithallison.com

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors