Forum Discussion
Survey Scoring Table
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 tab...
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.