How to add average line to measure bar chart

[Anonymous]

Hi, 

Need help to add an average line to bar chart.

These measures are calculated through CALCULATE and COUNT with FILTER, etc.

I want to show them in bar chart with and an average line shows across the bars. Like below:

However, when I use Line and Staked Column Chart and put the TEST to the Line Values, it shows below. Can someone suggest a way to solve.

Thanks in advance.

[MarkS · Accepted solution]

HI @Anonymous,

On the analytics tab of the clustered column visualization you can choose to add an average line.  Select the measure that you want to average from the dropdown for the measure.

[LupeBlonde]

What if I need to play with the value to calculate the standard deviation??

Is there a way to "Calculate" that average as a variable?

[Shelley]

This is awesome! THANK YOU! I couldn't get my measure to work. This gives me what I was looking for. Hopefully, my customers agree.

[Anonymous]

Is there a way to do this but on a horizontal bar chart?

[Anonymous]

HI @Anonymous,

It will be help if you share some sample data.

BTW, if your percentage value is from measure, I don't think you can direct use other measure to calculate average on it.

Regards,

Xiaoxin Sheng