cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
VitoMas Frequent Visitor
Frequent Visitor

How do i visualize this data?

I made a table with the answers of students to certain questions. The table looks like this.

QuestionStudent 1Student 2 Student 3Student 4 Student 5
1TrueFalseTrueBlankFalse
2FalseTrueTrueTrueBlank
3FalseTrueTrueTrueTrue
4FalseFalseFalseFalseTrue
5BlankBlankTrueTrueFalse

 

Now i would like to create a visual something like this

how to.png

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.

1 ACCEPTED SOLUTION

Accepted Solutions
natelpeterson New Contributor
New Contributor

Re: How do i visualize this data?

@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 1
natelpeterson New Contributor
New Contributor

Re: How do i visualize this data?

@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