Forum Discussion
Help: 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-30 section, 30-60 section, and 90+ section. I have data currently in a table that has invoice number, customer name, invoice date, due date, and amount. I also want to be able to hover over each section of the bar and get a quick pop up showing total $ and # of invoice. Can anyone help me out. I attached a snap shot of the table that i have.
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
3 Replies
If you can paste that sample data as text that would be great. I don't want to type all that. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi 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 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
