Forum Discussion

travbum's avatar
travbum
Icon for Advocate I rankAdvocate 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
Icon for Community Champion rankCommunity Champion
9 years ago

travbum

 

Put the three columns in value section of bar chart visual

 

 

  • travbum's avatar
    travbum
    Icon for Advocate I rankAdvocate 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
      Icon for Community Champion rankCommunity 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
        Icon for Advocate I rankAdvocate I
        9 years ago

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