Reference line based on x axis values

[#1]

Hello everyone,

I have a graph with y = some %  and x= time in month.

I would like to add a reference line which represents the goal for each month. For january to June 2015 , the reference value must have a value = 93 and for July to December 2015, the reference line must be equal to 95.

I have tried in the expression :

if(num([Month ]) <7, 0.93, 0.95) but it doesn't work, the reference line is always equal to 95%.

How can I do ?

Thank you for your answer

Have a good day.

Laura

[morganaaron]

As far as I know, a reference line is static across the whole range of your chart - so you won't be able to add any conditions to it, it can only be a static line.

Your best option would be to create another expression such as:

if( [your dimension] < [value], 0.93, 0.95)

Bare in mind this would show the link between the two as genuine movement however, so if you wanted two separate lines you'd need two expressions, one for the 0.93 and one for the 0.95.