Forum Discussion
Using Power BI with output from Forms
I am taking an output from Micrsoft Forms via Excel into Power BI. The output is a survey and that looks like TABLE A) and I need to create a visual like TABLE B)
TABLE A
| Event | Attendee 1 | Attendee 2 | Attendee 3 |
| EVT1 | Good | Poor | Average |
| EVT2 | Average | Poor | Average |
| EVT3 | Poor | Good | Poor |
TABLE B
| Event | Poor | Average | Good |
| EVT1 | 1 | 1 | 1 |
| EVT2 | 1 | 2 | 0 |
| EVT3 | 2 | 0 | 1 |
How is this done?
Thanks
Anonymous ,
In power query, click on [Attendee 1], [Attendee 2] and [Attendee 3], then click Transform-> Unpivot Columns, you will acheve the table as below:
Then click [Value] and click Pivot Column as below, you will achieve the expected table:
The result is as below:
Regards,
Jimmy Tao
1 Reply
Anonymous ,
In power query, click on [Attendee 1], [Attendee 2] and [Attendee 3], then click Transform-> Unpivot Columns, you will acheve the table as below:
Then click [Value] and click Pivot Column as below, you will achieve the expected table:
The result is as below:
Regards,
Jimmy Tao