Forum Discussion
bouyazbekj
Helper I
Helper IHelp: AR aging graph
Hello, I am new to power BI and trying to create a useful graph to show again per customer in a graph. So essentially 1 bar per customer and the bar total is the total amount broken down into 0-...
bouyazbekj add new column in model for aging days,
Aging Days = VAR days = DATEDIFF( Table2[Due date], TODAY(), DAY ) RETURN SWITCH ( TRUE(), days >= 91, "90+ Days", days >= 60, "60 - 90 Days", days >= 30, "30 - 60 Days", "0 - 30 Days")On stacked bar chart, add customer on x-axis, aging days as legend and amount outstanding as value and you will get the chart
bouyazbekjHelper I
Helper IHi Greg,
Sorry about that. Can you work with something like this?
| Customer | Invoice | Invoice date | Due date | Amount outstanding |
| Forge | 11521 | 15/5/2018 | 09/06/2018 | $ 83,000.00 |
| Dinerian | 11560 | 23/05/2018 | 15/06/2018 | $ 23,000.00 |
| CPG | 11570 | 31/05/2018 | 18/06/2018 | $ 12,562.00 |
| CPG | 11590 | 13/06/2018 | 12/07/2018 | $ 12,578.00 |
| Cenovous | 11666 | 11/07/2018 | 02/08/2018 | $ 93,215.00 |
| ARC | 11672 | 12/07/2018 | 05/08/2018 | $ 22,188.00 |
| ARC | 11690 | 17/08/2018 | 01/09/2018 | $ 2,369.00 |
| ECA | 11778 | 27/08/2018 | 18/09/2018 | $ 21,248.00 |
| ARC | 11779 | 27/08/2018 | 13/09/2018 | $ 698.00 |
| ECA | 11900 | 01/09/2018 | 29/08/2018 | $ 2,248.00 |
| ARC | 11200 | 31/10/2018 | 24/11/2018 | $ 24,548.00 |
| BTE | 13554 | 31/10/2018 | 26/11/2018 | $ 2,266.00 |
| BTE | 12697 | 31/10/2018 | 30/11/2018 | $ 88,963.00 |
| ARC | 12358 | 30/9/2018 | 01/10/2018 | $ 9,948.00 |
| ECA | 15885 | 25/10/2018 | 16/11/2018 | $ 14,488.00 |
| FRA | 16015 | 2/12/2018 | 22/12/2018 | $ 15,458.00 |
parry2k
Super User
Super Userbouyazbekj add new column in model for aging days,
Aging Days =
VAR days = DATEDIFF( Table2[Due date], TODAY(), DAY )
RETURN
SWITCH ( TRUE(),
days >= 91, "90+ Days",
days >= 60, "60 - 90 Days",
days >= 30, "30 - 60 Days",
"0 - 30 Days")
On stacked bar chart, add customer on x-axis, aging days as legend and amount outstanding as value and you will get the chart