Hide average line in column chart when only one bar is displayed

[zdenek_moravec]

Dear colleagues

I have a column chart with a date on x-axis and count of orders on the y-axis. I would like to display an average line over the bars, which displays an average value of the displayed bars values.

An easy solution is to switch to “clustered column chart”, which allows to enable average line on the “further analysis” tab. Everything looks good:

until the x-axis shows only one period (one day, one month or one year). Then the avg line is distracting and actually useless:

So my question is, how to set a column chart with an average line, which disappears, when the chart shows only one value/bar. 

See example AVG line in stacked column chart in case of one value.pbix.

I believe in a measure, which can detect number of periods displayed and which calculates the average of the bar values or sets the line value to blank based on count of displayed periods. One constrain is, that the date x-axis is managed by field parameters.

Thank You very much for any hint.

Zdenek Moravec

Cesky Krumlov, Czechia