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
    Icon for Microsoft Employee rankMicrosoft 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.

  • michaelwtk's avatar
    michaelwtk
    Regular Visitor
    Hi All, can anyone help me on the question above ?
    • RMDNA's avatar
      RMDNA
      Icon for Solution Sage rankSolution Sage

      Hi michaelwtk,

       

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

       

       

      • michaelwtk's avatar
        michaelwtk
        Regular Visitor

        Hi RMDNA, the photo as attached below. Thanks.