Forum Discussion

Tremor1981's avatar
Tremor1981
Frequent Visitor
3 years ago

Line Chart questions

Hello - 

I'm creating a dashbaord for an going construction project. I have data for total hours worked, phase code(type of worked done) and Quantity (the total materials installed). I would like a line chart that shows a running total of hours and quantity complete. (essentially how many quantities are complete per hour) example of data. Any suggestions? Thanks in advance

 

Hours

 

 

 

Quantities (work complete)

 

 

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Tremor1981 ,

     

    You could create a running total measure like this.

    Running Total = CALCULATE(SUM('Table'[Quantity]),FILTER(ALLSELECTED('Table'),[Date]<=MAX('Table'[Date])))

    Reference: Computing running totals in DAX - SQLBI

     

     

    Best Regards,

    Stephen Tao

     

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

    • Tremor1981's avatar
      Tremor1981
      Frequent Visitor
      3 years ago

      I have this already. What I am trying to do is have the qty in the x axis.