100% stack column chart with categorical counts over time

[am-person]

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
Draft	2/22/23
Approved	2/22/23
Closed	7/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
Draft	2/22/23
Draft	2/22/23
Revise and Resubmit	8/7/23
Revise and Resubmit	9/15/23
Approved	9/19/23
Open	11/15/23
Draft	2/22/23
Open	2/22/23
Draft	2/22/23
Draft	2/22/23
Draft	2/22/23
Draft	2/22/23
Approved	2/22/23
Draft	2/22/23
Draft	2/22/23
Draft	2/22/23
Approved	2/22/23
Draft	2/22/23
Draft	2/22/23
Approved	2/22/23
Approved	2/22/23
Draft	2/22/23
Approved	2/22/23
Draft	2/22/23
Open	2/22/23
Closed	2/22/23
Draft	2/22/23
Draft	2/22/23
Approved	2/22/23
Approved	2/22/23
Draft	2/22/23
Draft	2/22/23
Draft	2/22/23
Approved	2/22/23
Draft	2/22/23
Draft	2/22/23
Draft	2/22/23
Draft	2/22/23
Draft	2/22/23
Draft	2/22/23
Approved	2/22/23
Draft	2/22/23
Approved	2/22/23
Draft	2/22/23
Draft	2/22/23
Draft	2/22/23
Approved	4/27/23
Approved	2/22/23
Approved	2/22/23
Approved	2/22/23
Draft	2/22/23
Revise and Resubmit	2/22/23
Approved	2/22/23
Draft	2/22/23
Draft	2/22/23
Revise and Resubmit	7/6/23
Revise and Resubmit	7/20/23
Approved	8/3/23
Draft	2/22/23
Draft	2/22/23
Open	2/22/23
Draft	2/22/23
Approved	2/22/23
Draft	2/22/23
Draft	2/22/23
Open	2/22/23
Draft	2/22/23
Approved	2/22/23
Approved	2/22/23
Draft	2/22/23
Draft	2/22/23
Approved	2/22/23
Approved	2/22/23
Approved	2/22/23
Approved	2/22/23
Draft	2/22/23
Revise and Resubmit	2/22/23
Approved	2/22/23
Closed	2/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
Draft	2/22/23
Open	2/22/23
Draft	2/22/23
Draft	2/22/23

Any help is greatly appreciated.

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[am-person]

That worked!  Thank you!

[Ashish_Mathur]

You are welcome.

[am-person]

New issue with the new year.  When I adjust the running status count to include the current month with this measure:

Running Status count = CALCULATE([Count],DATESYTD('Calendar'[Date], "31/1"))

The visual just copies over the December 2023 data onto the new month and the January 2024 data is not exhibited in the matrix. 

How to fix this?  Thanks for any help.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file and show the expected result very clearly.