Forum Discussion
Solved
Help with a line chart
Hello, I have created a line chart to summarize production data over a 5yr period. It seems like, for some reason, power bi is summarizing the data. If you look at the y axis on both sides of ...
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
- Why do you expect the secondary Y-axis to have a range between 0 and 4k when your maximum tons delivered are over 6k?
Gabry
Super User
Super UserFirst, you need to drill down into the dates. If you're looking at an entire year, I assume it should be aggregated. So, if you need daily granularity, you will need to drill down.
For the second axis, right-click and select 'Do not aggregate.' Currently, the values are being summed
Can you explain how to add this drill down?