Forum Discussion
How do i visualize this data?
I made a table with the answers of students to certain questions. The table looks like this.
| Question | Student 1 | Student 2 | Student 3 | Student 4 | Student 5 |
| 1 | True | False | True | Blank | False |
| 2 | False | True | True | True | Blank |
| 3 | False | True | True | True | True |
| 4 | False | False | False | False | True |
| 5 | Blank | Blank | True | True | False |
Now i would like to create a visual something like this
Note: The chart is not based on the data in the table. I just made it to make things a little clearer.
Any help would be greatly appreciated.
VitoMas - Try the following:
1. In Power Query, you will want to select the Question column, and then Unpivot Other Columns. That will transform your table into 3 rows: Question, Attribute (Student), and Value (Answer).
2. You can change the names of the columns to Question, Student and Answer.
3. Create a DAX Measure:
Answer Count = COUNTROWS([Your Table])
4. Create a Clustered Column Chart with your new measure as Value, Answer as Legend, and Question as Axis.
Hope this helps,
Nathan
1 Reply
VitoMas - Try the following:
1. In Power Query, you will want to select the Question column, and then Unpivot Other Columns. That will transform your table into 3 rows: Question, Attribute (Student), and Value (Answer).
2. You can change the names of the columns to Question, Student and Answer.
3. Create a DAX Measure:
Answer Count = COUNTROWS([Your Table])
4. Create a Clustered Column Chart with your new measure as Value, Answer as Legend, and Question as Axis.
Hope this helps,
Nathan