Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
I'm looking is there a way to create stacked chart as below
Thank you for your help
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 :
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 :
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