cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michaelwtk Frequent Visitor
Frequent Visitor

Group Bar chart

 
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

 

BarChart.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Group Bar chart

Hi @michaelwtk,

 

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

1.PNG  2.PNG

 

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

3.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
michaelwtk Frequent Visitor
Frequent Visitor

Re: Group Bar chart

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

Re: Group Bar chart

Hi @michaelwtk,

 

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

 

2.PNG

 

michaelwtk Frequent Visitor
Frequent Visitor

Re: Group Bar chart

Hi RMDNA, the photo as attached below. Thanks.

BarChart.JPG

Community Support Team
Community Support Team

Re: Group Bar chart

Hi @michaelwtk,

 

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

1.PNG  2.PNG

 

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

3.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
michaelwtk Frequent Visitor
Frequent Visitor

Re: Group Bar chart

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