Forum Discussion

sdukes_88's avatar
sdukes_88
Frequent Visitor
9 years ago

Cumulative Line Chart Help

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

Need Help

6 Replies

  • Baskar's avatar
    Baskar
    Resident Rockstar
    9 years ago

    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's avatar
      sdukes_88
      Frequent Visitor
      9 years ago

      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's avatar
        Baskar
        Resident Rockstar
        9 years ago

        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.

         

         

         

         

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      sdukes_88
      Frequent Visitor
      9 years ago

      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