cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carlG
Helper I
Helper I

Categorise Likert Survey Responses

Hi PowerBi Community,

Still fairly new to powerBi and hitting a brick wall with queries/relationships.

 

I need to build a query that takes data from excel responses, (o365 Likert data) and applies a value instead of the text string that is being created. I have tried to use the additional column (pictured) but as the column count will exceed 100+, seems like there is a better way than this manual method.

addaditionalcolumn.png

 

I also need to put categories on each column, as seen in the sample survey (3D Printers, CNC, etc.)

survey example.png

Survey Sample Link

 

 

At a loss, could do easily in Access, trying to see if PowerBi can handle. Any hints would be appreciated

1 ACCEPTED SOLUTION

Managed to resolve it in the end

 

Merge Queries with a new table with the likert String and associated likert value on a separate table.

View solution in original post

4 REPLIES 4
V-pazhen-msft
Community Support
Community Support

@carlG 

So the survey responses are recorded as Text string? If that's the case, you can work on a copy of the excel. You could replace(Ctrl H) the text strings to numbers in Excel than import into Power BI. Make sure the you choose the correct format when replacing.

Excel Replace text to number.JPG

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Thank you for the info,

 

Was hoping to automate it to eliminate user error. as the survey will be completed monthly.

Was almost thinking a lookup table of sorts if it exists in powerbi

amitchandak
Super User
Super User

@carlG , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Managed to resolve it in the end

 

Merge Queries with a new table with the likert String and associated likert value on a separate table.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.