Forum Discussion
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, ...
that is odd. Would you be able to provide a sample PBIX?
lbendlin
Super User
Super UserHave you considered creating groups from your column values? Right click the column, New Group.
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
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.
I just have Sum of Type in the Chart. When I right click a column Group is greyed out
- lbendlin
that is odd. Would you be able to provide a sample PBIX?