Help with a line chart

Buddy, the moving average on what field should be calculated? On total power?

Well I've looked at the pbix and:

• Why do you expect the secondary Y-axis to have a range between 0 and 4k when your maximum tons delivered are over 6k?
  
  

   

• Instead for the Y axis I suppose it's wrong your moving average formula. Try with this
  
  
  Moving Average Total Power (28 Day) =

  CALCULATE(

      AVERAGE('Elec Prod'[Total Power]),

      DATESINPERIOD(

          'date'[Date],

          MAX('date'[Date]),

          -28,

          DAY

      )

  )
  
• Not sure why you set the relationship between datetable and Elecprod bidirectional. I think you should avoid bidirectional.

Let me know if I helped you