Forum Discussion

michaelwtk's avatar
michaelwtk
Regular Visitor
8 years ago
Solved

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 ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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

  • michaelwtk's avatar
    michaelwtk
    Regular Visitor
    8 years ago

    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

  • stewarte18's avatar
    stewarte18
    Regular Visitor
    6 years ago

    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.