Cumulative line chart

[Anonymous]

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 

[mangaus1111]

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.

[amitchandak]

@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]

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]

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.