Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cumulative line chart

Hi. 

 

Hi. 

How do I make a cumulative line chart? I tried to do the "running totals" in quick measurement but it shows me a incorrect visual perhaps I used the wrong measurements. 

 

I would like to have a rising line so e.g. 06/09/2022 has a total of 4 and not 1. 

 

 

Best regards,

Lisa 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , Create a measure with help from date table and use that in line, where date on axis will be from date table

     

    Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

     

    or

     

    Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

     

    Running Total/ Cumulative: https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=41

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      But what if my values is not numeric? It is not a sales value but the occurrence of different categories. 

      Can I still use the same equation? 

      • v-xiaotang's avatar
        v-xiaotang
        Community Support
        3 years ago

        Hi Anonymous 

        Thanks for reaching out to us.

        Just need to make small changes to the code, you can share some sample data then I'll change the code to suit your needs.

         

         

        Best Regards,

        Community Support Team _Tang

        If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • mangaus1111's avatar
    mangaus1111
    Solution Sage
    3 years ago

    Hi Anonymous ,

    try this measure

    RT  =

    VAR CurrentDate= SELECTEDVALUE (Date[Date] )

    RETURN

        CALCULATE (

            [Your Measure],

            Date[Date]<= CurrentDate

        )

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.