Showing monthly average unit price on chart

[dnapll]

I'm using the line and clustered column chart. Column represents the revenue and line represents the volume. How can I show the monthly average unit price in the chart? Currently using tooltips but hovering over the bars for every month is cumbersome. 

[v-yuezhe-msft · Accepted solution]

@dnapll,

You can drag average to Line values as shown in the following screenshot. If you need to show average for different legends, create three average measures for the legends, then drag these measures to Line values section.



Regards,
Lydia