Forum Discussion

VitoMas's avatar
VitoMas
Frequent Visitor
7 years ago
Solved

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 Fals...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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