Need help with Clustered Column Chart

[annam]

I have this data where I need to calculate 2 calculations for previous, current and next month. Basically to track which payemnt are guaranted in current month, how much much will be guranted next month. Not sure why chart is showing equal bars

[Joe_Barry]

Hi @annam 

Are you usinga  Date Table in your Data Model? If yes, please tyr this.

• Create an Active one to many relationship from the date table to the Invoice Date
• repeat for the Est invoice Date and Invoice accepted date, but this will automatically be in active
• Create the first measure

Invoiced =
SUM(Table[Total Amount])​

• Create the 2nd

Est. invoice =
CALCULATE([Invoiced], USERELATIONSHIP(Date[Date], Table[Est. Invoice Date]))​

• Create the 3rd

Invoice Accepted =
CALCULATE([Invoiced], USERELATIONSHIP(Date[Date], Table[Invoiced Accepted Date])​

Add the date from the date table to a visual then the measures

Hope this helps

Joe