How to create a stacked bar chart with different categories and monitor with date

[Eryka90]

Hi All,

I would like to create stacked chart to monitor my due date status (Today Due, Not Due, Pass Due). Here is sample of my data

PO Number	Net Due Date
SL07868581INV	11/18/2023
SL134219	11/28/2023
SLI-40094530	11/21/2023
SLI40223844	11/5/2023
SLI40223910	11/6/2023
SLI40224258	11/13/2023
SLI40224470	11/18/2023
SLI40224543	11/19/2023
SLI40224600	11/15/2023
SLI40224602	11/20/2023
SLI41020661	11/1/2023
SLI41021645	11/30/2023
SLI41029173	11/9/2023
SLI41029436	11/30/2023
SLI41818507	11/12/2023
SLI41818985	11/13/2023

I did create a DAX for the status as below

New_Due Status =

IF(ISBLANK('Pending Items'[Net Due Date]), "Due Date Blank",

    IF('Pending Items'[Net Due Date] > TODAY(), "Not Due",

        IF('Pending Items'[Net Due Date] < TODAY(), "Past Due", "Due Today")

    )

)

However my chart showing like this

I'm looking is there a way to create stacked chart as below

Thank you for your help

[Ritaf1983 · Accepted solution]

Hi @Eryka90 

Assuming I understand correctly, the goal is to display the number of invoices in the system for each day, categorized by status.

In addition to the classification column you added, you need to calculate the cumulative quantity.

Since your data for today is all in the same status because 2023 is all before today, I have changed the data to illustrate the solution.

The first step is the date table :

Then I created a measure :

count_invoices =

VAR LastVisibleDate =

    MAX ( 'dim_date'[Date] )

VAR FirstVisibleDate =

    MIN ( 'dim_date'[Date] )

VAR LastDateWithSales =

    CALCULATE (

        MAX ( 'Table'[Net Due Date] ),

        REMOVEFILTERS ()  

    )

VAR Result =

    IF (

        FirstVisibleDate <= LastDateWithSales,

        CALCULATE (

           COUNTROWS('Table'),

            'dim_date'[Date] <= LastVisibleDate

        )

    )

RETURN

    Result

the last step is to put all the data in the desired graph :

The pbix is attached you can follow my steps

More information about the date table is here :

https://radacad.com/all-in-one-script-to-create-calendar-table-or-date-dimension-using-dax-in-power-...

Running totals here :

https://www.daxpatterns.com/cumulative-total/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly