Forum Discussion

jwint's avatar
jwint
Frequent Visitor
1 year ago
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 ...
Need Help
Tips and Tricks
  • Gabry's avatar
    Gabry
    1 year ago

    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

jwint's avatar
jwint
Frequent Visitor
1 year ago

can you see this better?

  • Gabry's avatar
    Gabry
    Super User
    1 year ago

    First, 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

    • jwint's avatar
      jwint
      Frequent Visitor
      1 year ago

      Can you explain how to add this drill down?  

      • Gabry's avatar
        Gabry
        Super User
        1 year ago

        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.