Forum Discussion

travbum's avatar
travbum
Advocate I
9 years ago
Solved

Data from multiple columns in one visual

I have a survey question: Which of these did you do: A) I did A B) I did B C) I did C   which results in a table: I did A I did B I did C TRUE TRUE     TRUE TRUE       ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Another way is:

     

    Step 1

     

    Go to Edit Queries

     

    Select your columns with answers.

     

    Transform - Unpivot Columns

     

    Step 2

     

    In the bar chart put Attribute (You can change the name to Question or another) in axis and Values(You can change the name to answer or another) in Value section

     

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

travbum

 

you need to create a measure for each column:

 

A = CALCULATE(COUNTROWS(Survey),Survey[I did A]=True)

B = CALCULATE(COUNTROWS(Survey),Survey[I did B]=True)

C = CALCULATE(COUNTROWS(Survey),Survey[I did C]=True)

travbum's avatar
travbum
Advocate I
9 years ago

Is there no other easier/alternative way to do things? I"ve got like 40 survey questions like this.

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    Another way is:

     

    Step 1

     

    Go to Edit Queries

     

    Select your columns with answers.

     

    Transform - Unpivot Columns

     

    Step 2

     

    In the bar chart put Attribute (You can change the name to Question or another) in axis and Values(You can change the name to answer or another) in Value section