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

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