How do i visualize this data?

[VitoMas]

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.

[Anonymous · Accepted solution]

@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