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,  others by themself so the data is shown in the column chart as 1 sum instead of a separte for each.  Is that possible.  If so how?

 

 

Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

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

     

7 Replies

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

    Have you considered creating groups from your column values? Right click the column, New Group.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Right click doesnt seem to give me the option to do that.  And would this apply all the time or is it only a 1 time thing?

       

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

        Are you trying to group a measure? That won't work. Only works on columns.

         

        You would initially create the group with the available values. You may need to review the settings when your new values are added.