Forum Discussion

am-person's avatar
am-person
Regular Visitor
2 years ago
Solved

100% stack column chart with categorical counts over time

I need help creating a 100% stack column chart.  I created a measure to do a cumulative count on the categories that I am trying to graph:

 

RT Status count =
    CALCULATE(
        COUNT(Submittals[Created On]),
        FILTER(
            ALLEXCEPT(Submittals, Submittals[Status]),
            Submittals[Created On] <= MAX(Submittals[Created On])))
 
the matrix that this makes is:

and gives the 100% stack graph of:

Is there a way to create the graph so that the previous month counts carry over?  I guess I am needing the graph to be more representing this matrix table (which I made cut and pasting to explain my point):

 Here is truncated data from my table

Approved 2/22/23
Approved 2/22/23
Approved 2/22/23
Approved 2/22/23
Approved 2/22/23
Revise and Resubmit 2/22/23
Approved 7/18/23
Approved 8/15/23
Approved 2/22/23
Draft2/22/23
Approved 2/22/23
Closed7/3/23
Approved 7/7/23
Approved 7/19/23
Approved 7/25/23
Approved 8/9/23
Approved 11/9/23
Approved 9/9/23
Approved 9/18/23
Approved 2/22/23
Draft2/22/23
Draft2/22/23
Revise and Resubmit 8/7/23
Revise and Resubmit 9/15/23
Approved 9/19/23
Open11/15/23
Draft2/22/23
Open2/22/23
Draft2/22/23
Draft2/22/23
Draft2/22/23
Draft2/22/23
Approved 2/22/23
Draft2/22/23
Draft2/22/23
Draft2/22/23
Approved 2/22/23
Draft2/22/23
Draft2/22/23
Approved 2/22/23
Approved 2/22/23
Draft2/22/23
Approved 2/22/23
Draft2/22/23
Open2/22/23
Closed2/22/23
Draft2/22/23
Draft2/22/23
Approved 2/22/23
Approved 2/22/23
Draft2/22/23
Draft2/22/23
Draft2/22/23
Approved 2/22/23
Draft2/22/23
Draft2/22/23
Draft2/22/23
Draft2/22/23
Draft2/22/23
Draft2/22/23
Approved 2/22/23
Draft2/22/23
Approved 2/22/23
Draft2/22/23
Draft2/22/23
Draft2/22/23
Approved 4/27/23
Approved 2/22/23
Approved 2/22/23
Approved 2/22/23
Draft2/22/23
Revise and Resubmit 2/22/23
Approved 2/22/23
Draft2/22/23
Draft2/22/23
Revise and Resubmit 7/6/23
Revise and Resubmit 7/20/23
Approved 8/3/23
Draft2/22/23
Draft2/22/23
Open2/22/23
Draft2/22/23
Approved 2/22/23
Draft2/22/23
Draft2/22/23
Open2/22/23
Draft2/22/23
Approved 2/22/23
Approved 2/22/23
Draft2/22/23
Draft2/22/23
Approved 2/22/23
Approved 2/22/23
Approved 2/22/23
Approved 2/22/23
Draft2/22/23
Revise and Resubmit 2/22/23
Approved 2/22/23
Closed2/22/23
Approved 2/22/23
Approved 2/22/23
Approved 7/28/23
Approved 2/22/23
Revise and Resubmit 2/22/23
Approved 8/1/23
Approved 8/17/23
Approved 6/20/23
Draft2/22/23
Open2/22/23
Draft2/22/23
Draft2/22/23

 

Any help is greatly appreciated.

Need Help