Forum Discussion

mwinds's avatar
mwinds
Icon for Helper I rankHelper I
4 years ago

Cumulative line chart

Hi all,   I've having issues with this measure. The line chart is cumulative for some months but not for others. Here's what I've got.     Actual Cumulative = CALCULATE(SUM(InvoiceDetails[Total...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

mwinds , You should date/period from date table on axis and measure should be like

 

Budget Cumulative =
var _max = maxx(allselected(InvoiceDetails) , InvoiceDetails[Month invoiced])
return
CALCULATE(SUM(Spendperlot[Total]),FILTER(ALL('Date'),'Date'[Date]<=MAX('Date'[Date]) && 'Date'[Date]<= _max ))

  • mwinds's avatar
    mwinds
    Icon for Helper I rankHelper I
    3 years ago

    Hey, 

    Thanks for the reply. 

    The chart looks like this now if i chose catergorical in the x-axis type 

    or like this if i choose continuous in the x-axis type.

     

    Any way i can get it to show every month and for the line to go up gradually rather than in chunks.

    If i choose to add Month name and year in the x-axis, sort by month and drill down, i get this. Not too sure what's going on here.

     

    File is here https://drive.google.com/file/d/1yXye3LVBp-ZA3Bz31-9_notHQXTaPTQh/view?usp=sharing