Forum Discussion

annam's avatar
annam
Frequent Visitor
2 years ago

Need help with Clustered Column Chart

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

 

1 Reply

  • Joe_Barry's avatar
    Joe_Barry
    Solution Sage
    2 years ago

    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