How to change the series in Analytics Pane

[nleuck_101]

Hello Everyone,

I need to change the series to on my Average line to the Analytics Pane but when I select the Series there is only one there. Is there a way to select a different measure for my Series in the Analytics Pane? I created a separate measure that gives me my Average but I want that line to behind the bars in the chart and you can't do that on a line and clustered column chart. My Average excludes the current month from the calculation.

Any help would be greatly appreciated!

Thanks,

[nleuck_101 · Accepted solution]

Instead of trying to use an Average line, I needed to use a Constant line. For the value I use Conditional formatting and selected my Average measures that excludes the current month.

[nleuck_101]

Does anyone know if this is possible? Are you able to change the series in the Analytics Pane and if so how?