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 give me same value

 

  • 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

6 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    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

      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

      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.

    • RMDNA's avatar
      RMDNA
      Solution Sage

      Hi michaelwtk,

       

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