Forum Discussion
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!
CM
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
7 Replies
v-lili6-msftCommunity Support
HI, Anonymous
You could use “all” functions in DAX to create a national average measure:
If not your case, please share some simple sample data and expected output.
Best Regards,
Lin- v-lili6-msft
hi, Anonymous
Do you mean that there is a field in legend value, if so, it could not add a measure again.
and you need to use the Analytics pane in Power BI Desktop.
https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane
Best Regards,
Lin