Dynamic Multiple Vertical Reference Lines in Line Graph

[prachisangewar]

Hi,

I have a line graph with Date as my X Axis.

I need to have reference lines on all Month End dates.I have created a flag for Month End dates in my Calendar table.

Please suggest if I can show multiple lines using a single expression.

I have tried to give condition in the Expression but the line does not show.It only works if I have just one Date (e.g I tried with Max Date Variable).

Please advise!

[prieper]

Think not, that this is possible with reference lines (output is always one value to my understanding).

But you may choose a different color for your bars or datapoints, depending the date.

Peter

[Sergey_Shuklin]

Hi, Prachi!

If you use a line chart you can try to convert it into a combo chart, next you can add a bars which will be your vertical lines. You also can make it less noticeable with transperacy. The calculated value of bars may be the max value among the all values of line.

P.S.: reference lines is the only horizontal lines

P.P.S.: one expression = one reference line

[Frank_Hartmann]

this might be helpful:

Multiple reference lines in one statement

[prachisangewar]

Hi Frank,

Thanks for the suggestion, but the Error bar doesn;t seems to show my last monthend date(eg if I select Jan t0 Dec 2016, the error bars appear only till 30th Nov), but the Symbols are shown for all the MonthEnds.So my expression is ok.Any her setting I need to change for the Error Bars?

Thanks

[Frank_Hartmann]

Please prepare a small sample which demonstrates the problem.