Set a static line on a combo chart with filtered X-axis

[Anonymous]

Hi all,

I am trying to set a static target line on following combo chart:

X-axis is filtered to last 6 months.

I would like to add a 85% target line on the chart but:

• I can't acces the Analysis pane
• When I try to add a measure like Targer = 0,85, I get following result:

The measure is displayed for all months (01/2016 to 12/2020).

I guess ther is some kind of filter to add in my formula, how can I build it?

Thanks a lot!

[Anonymous · Accepted solution]

I found, thanks to a colleague: I just had to make reference to a measure already used in my chart so here is what I did:

Measure.ROT.target.ETO = [Measure.Selection.ROT]/[Measure.Selection.ROT]*0,85

[Measure selection ROT] being the measure used to draw the black line of my chart.