Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi all,
I have a survey from survey monkey that I have loaded into Power Bi. Its a column (the question) with the response below it as the value.
In addition to this, I created a table that outlines how many points each value is worth below:
What I'm trying to do is either create a new table that replaces the responses with point values (it would look like the top picture except with points as values)
OR
Come up with a way to replaces the words within the table with point values.
Can anyone share with me how I would best go about this?
Thank you in advance!
Hi @Anonymous, Usually for Survey questions, it is easier if you pivot your table.
1.) Pivot your Question table as below.
ID | Question | Answer |
1 | Question1 | Answer1 |
2 | Question2 | Answer2 |
3 | Question3 | Answer3 |
2.)Points table,
Answer | Points |
Answer1 | 3 |
Answer2 | 1 |
Answer3 | 0 |
Create 1-1 or 1-* relationship between Points[Answer] and Question[Answer] columns,
And then create a new table visual, with columns Question[Question] and Points[Points].
Hope this helps.
Thanks,
Thanks @snokku. I would do that but how do I not pivot the ID portion of the row. The respondant's ID is on the same row as the responses. Is there a way to pivot just the responses while keeping ID as a column?\
Thanks in advance.
@Anonymous , You can replace option in Power Query editor /Data Transformation
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@amitchandak My forum status won't let me share pbix documents for some reason. But I'll create tables in here if that helps.
How often are employees equipped? | Are observational routines utilized? | Do these take into consideration safety guidelines? |
Sometimes | Yes | No |
Sometimes | 2 |
Yes | 1 |
No | 0 |
I want these to turn into this:
How often are employees equipped? | Are observational routines utilized? | Do these take into consideration safety guidelines? |
2 | 1 | 0 |
Does this help?
User | Count |
---|---|
90 | |
88 | |
85 | |
80 | |
49 |
User | Count |
---|---|
150 | |
142 | |
112 | |
73 | |
55 |