add an average line on a Line and Clustered Column Chart

[mbd]

Hi, 

I'm using a Line and Cluster Column Chart to display three different data categories. The x axis is the date. 

Example: data is in the form below

Date        A    B    C

8/1/17     5     3    7

8/2/17     4     8    2

8/3/17     6     5    9

etc

I want to add an average line for one of the data categories. The Line and Cluster Column Chart does not have an Average Line in the Analytics, only a trend line. When I try to calculate an average measure or use Quick measures i just get the data values returend because I'm including date in the graph

Is there a way to add an average line in?

Thanks

[v-qiuyu-msft · Accepted solution]

Hi @mbd,

You can create a measure to calculate average values, take the column A as a example:

Avg(A) = CALCULATE(AVERAGE('Table2'[A]),ALLSELECTED('Table2'))

Then drag this measure to the Line Values property of the combo chart. For details, you can download attached pbix file to have a look.

Best Regards,
Qiuyun Yu

[mbd]

Hi, 

Ignore my question on Shade Area. I just needed to update my desktop version.

Thanks for the help

[mbd]

 Thanks!, that worked.

I have two of my data sets as lines and one as a column. I want to shade one of the line data sets. 

In Format, I've turned Shade Area on, but it won't let me turn off Shade Area for my other data set. It shades both of them and now the Avg measure also. 

Is there a way to add shade area to only on line?