Help: AR aging graph

[bouyazbekj]

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. 

[IMG]http://i67.tinypic.com/24g1w9e.png[/IMG]

[Greg_Deckler]

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

[bouyazbekj]

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

[parry2k · Accepted solution]

@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