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 li...
Need Help
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.