Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to create a compared Bar Chart

Hi, 

I have two columns of data call them "Answer 1" and "Answer 2" from a survery result I sent out. The response data set for both questions are the same. They are either: 

 

  • Extremely difficult (1)
  • Somewhat difficult (2)
  • Neither easy nor difficult (3)
  • Somewhat easy (4)
  • Extremely easy (5)

I currently have the results in two seperate clustered column charts seen below. However, I want to have the counts for each response visualized next to each other on the same chart. So for example from my charts below the count bar for "Very Important" of 55 from Answer 1 would be grouped with the count of "Very Important" of 69 from Answer 2. 

 

This is not the solution but here is what I want the graph to look like with the counts of each response grouped: 

Thanks!

  • Hi,

    In the Query Editor, select all columns other than the 2 Answer columns, right click and select "Unpivot Other Columns".

3 Replies

  • Can you upload a pbix file so we can see the data? Or show us the table and measures you have for the count?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Here are the two data columns. The left column would be "Answer 1" and the right column would be "Answer 2"

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User

      Hi,

      In the Query Editor, select all columns other than the 2 Answer columns, right click and select "Unpivot Other Columns".