How to create a compared Bar Chart

[scorreia3423]

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!

[scorreia3423]

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

[Ashish_Mathur · Accepted solution]

Hi,

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

[MDodds]

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