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?
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!
I was right clicking on the columns not in the visualizations part