Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to group items in stacked Column Chart

I have a bunch of data in which I do a sum of the count in a stacked column chart.  I end up with about 15+ different its in the column.   I would like to combine some items 3 in some. 4 in others,  ...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    that is odd. Would you be able to provide a sample PBIX?  

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I just have Sum of Type in the Chart.  When I right click a column Group is greyed out

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

that is odd. Would you be able to provide a sample PBIX?  

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Unfortunately no.. i think it is to large to share. Basically 

     

    Table 1

    Has an Id,  Title and date,  Status., other information   

     

    The ID can show up multiple times with different day with a different status

     

    Table 2 has  main ID and a another ID that it is linked to.   Its basicall just keeping track that ID1 is linked to ID2

     

    For my visual it is a stacked column chart that sums the Status by date.  In the Y axis I have sum of status in the X I have date,.  But some states are essentially the same and i want to combine them in the column chart as on.

     

    Hope that helps and appreciate the replies!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I was right clicking on the columns not in the visualizations part