Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cumulative line chart in combo chart

Hi there

 

I currently have a combo chart that looks like this:

 
 
 

 

The chart is based on a measure "Hours Saved" and shows values for each transaction date.

 

I would like to additionally have a line chart added that shows the cummulative value of hours saved up to that date.

 

Something like this:

 

Anyone know how this can be done?

Keep in mind that i do not have the values for hours saved each day in a table but it is made using a measure.

 

Thanks

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous 

    Create a cumulative measure like this

     

    Cumm = CALCULATE(SUM(Table[hours]),filter(date,date[date] <=maxx(date,date[date])))
    Cumm = CALCULATE(SUM(Table[hours]),filter(date,date[date] <=max(Table[Date])))

     

    And use in combo chart like line and bar or line and clustered

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandak 

       

      Using your solution seems to just give the same result without accumulation.

       

      My "Hours Saved" measure as calculated like this:
      Hours Saved = SUMX(QueueDB; RELATED(queuesROI[timeValueMin]))/60
       
      I tried to calculate it this way:
      Cumm = CALCULATE([Hours Saved];FILTER(QueueDB;QueueDB[transactionEND] <=MAX(QueueDB[transactionEND])))
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

         

        Refer the formula below and see if it helps.

        Measure = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[date]))

Measure 2 = CALCULATE([Measure],FILTER(ALL('Table'),'Table'[date]<=SELECTEDVALUE('Table'[date])))

         Here's the result about my sample data.

        If this not help, please share some sample data if you don't have any Confidential Information.

         

        Best Regards,

        Jay

         

        Community Support Team _ Jay Wang

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