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

     

travbum's avatar
travbum
Advocate I
9 years ago

Ah, that is not how I thought to do that. Thanks! How would I get a legend in there? All I have in the legend now is "Count of Q1_A", "Count of Q1_B","Count of Q1_C"

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