Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Total average line on line chart

Hi,   I have a line chart showing trends by state. Please can you tell me how to draw a national average line (it should undulate each week, not just be a straight horizontal line)   Thanks!   ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    I'm afraid it couldn't achieve in Power BI for now.

    If there is one field in lenged value, it couldn't add two measure into Values.

    As a workaround, you could add a new line chart and set the same x-axis and the national average measure.

    Then keep two measure X-axis and Y-axis coincident.

     

    Best Regards,
    Lin

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI Lin,

 

Analytics pane can create a straight horizontal (average) or angled (trend) line but it can't create a rolling average? The below screenshot shows a horizontal line from the analytics pane and a moving average that I've drawn on in thick black dashed line that I'm aiming for. Does that make sense? (Yes I have a measure in the legend field well)

 

 

Thanks,

 

CM

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous 

I'm afraid it couldn't achieve in Power BI for now.

If there is one field in lenged value, it couldn't add two measure into Values.

As a workaround, you could add a new line chart and set the same x-axis and the national average measure.

Then keep two measure X-axis and Y-axis coincident.

 

Best Regards,
Lin

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Many thanks Lin, that workaround works for the time being.

    • v-lili6-msft's avatar
      v-lili6-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      hi, Anonymous 

      You are welcome. :smileyvery-happy:

      could you please mark the helpful replies as Answered?

       

      Best Regards,

      Lin