Cumulative Line Chart Help

[sdukes_88]

Hi,

I need a cumulative line chart but am stuck.

I have month along the bottom of the chart and then it needs to do a sum of funding but it has to sum whatever is in RateBand and be able to filter on Group2 and FundLine.

The top chart is fine as it shows the funding by month but then the bottom chart needs to sum funding but take into consideration the groupings defined by the slicer.

Any help or tips appreciated!

Thank you

Simon

[v-yuezhe-msft]

Hi @sdukes_88,

I make a test using the following sample data.

Firstly, add an index column in your current table.

Secondly, add a new column using  the following formula.

Cumulative = Calculate ( Sum ( Table4[Funding]), CalculateTable ( Filter ( AllExcept ( Table4, Table4[RateBand] ), Table4[Index]<= Max ( Table4[Index] ) ) ) )

Thirdly, create line chart as follows.

Thanks,
Lydia Zhang

[sdukes_88]

Hi Lydia,

Thanks for this and apologies for delay in my response.

I'll give this a try, but worried my data won't work with the index as there are also multiple sites (i.e. Site 1 - Site 7).

Thanks

Simon

[Baskar]

Cool Dude,

If u remove the Legend from the line chart u can get the Total , I mean sum of Value which u seen in the above bar chart.

[sdukes_88]

Sorry I don't think I was very clear. I mean I need the cumulative total running across the months.

So in the line chart, Aug+Sep+Oct etc

So if Aug is 20,000 and September is 300,000 the point at September for the line chart should be 320,000 etc 

[Baskar]

Ooh Cool,

Create new measure for this,

Running Count1 = CALCULATE(COUNTA('Date Master'[MonthInCalendar]),FILTER(ALLSELECTED('Date Master'[Date]), 'Date Master'[Date] <= MAX('Date Master'[Date])))

let me know if any help.

[sdukes_88]

Thanks for this - my only problem is that Month is a text field i.e. 01-Aug, 02-Sep etc so it doesn't seem to like this.

If it helps I have 'Period' which is numeric?