Setting Average Line

[Anonymous]

I would like to add an average line to my visualization.  The issue I'm running into is this average can be variable depending on the client selected.  How do I get the line to change for each client automatically rather than having a measure that would need to be manually changed?

[v-shex-msft · Accepted solution]

Hi @Anonymous,

You can click on analytics panel to add average line based amount column, it will dynamic changes based on current item.

Notice: average line only show summary average value based on selected column, it not affect by current group and can't generate multiple average lines based on category column.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @v-shex-msft - I played around with the data and visualizations some more and was able to accomplish what you suggested as the solution.  Thanks!

[Anonymous]

Hi @v-shex-msft - I'm needing to accomplish what I want to do in a Line and Clustered Column chart as I have a count on the left Y-axis and aging of those counts on the right Y-axis.  I'm wanting to do the average of the aging on the right Y-axis to show which item's aging are falling above or below the average line.  It seems in order to do what you showed is using a Clustered Column chart which ends up eliminating one of the data points.  If there is a better visualization that could be used to accomplish this, I'm open to changing it.  Thanks for the help.