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?
Can you explain how to add this drill down?
1. Navigating to the Next Level in a Visual:
If you hover over the visual, you should see an arrow pointing down at the top right.
Click on this arrow, and it should take you to the next level. I think It should work, not sure
2. Changing the Summarization Method:
To adjust how values are displayed, right-click on the field or the sum in the visual.
Then, select "Don't Summarize" from the context menu to see the raw data instead of a summarized total.