Group Bar chart

[michaelwtk]

 
Given a dataset in the table below, can guide me how to create a group bar chart as shown above? Thanks
I have tried, but once i drag the ColumnA and Column B inside the axis, the bar chart give me same value

[v-yulgu-msft · Accepted solution]

Hi @michaelwtk,

You may need to unpivot original table structure in Query Editor mode.

 

Then, insert a clustered column chart, add corresponding fields to chart as below:

Best regards,

Yuliana Gu

[stewarte18]

I'm having a similar issue.  However, the data I'm trying to make into a bar chart cannot be combined into one column.  Below is how the chart looks now with an example of how I would like for it to look.  Any help is appreciated.

[michaelwtk]

Thanks Yuliana,

tweo more question.

if i want to sort the x-axis , Neutral, Sad, Happy, how to configure this ? 

if i would like to add both number and percentage , i need to create a new measure? how to achieve that. Many Thanks

[michaelwtk]

Hi All, can anyone help me on the question above ?

[RMDNA]

Hi @michaelwtk,

There are no visuals in your post (see below). Try editing your post and attaching the chart.

[michaelwtk]

Hi RMDNA, the photo as attached below. Thanks.