Can we set only one target and one

[#1]

HI All

    I has one question about this when I  has one line chart like the below

Yaxis is FaultLevel， he has three values : critical, major, minor

and they set target 98,85,70, I set the target line in the line chart , so the line chart will has six line.

now i want in my line chart , when I filter to show critical, only the level value and his targt value line can show, that means in the line chart we can only see 2 lines , the select level and its target, can we do that?

[SergeyMak]

Hi zhang,

Yes we can.

Can you post your app? and I will manage to show you how.

Regards,

Sergey

[#3]

HI Sergey

   Thanks for your answer, I can't upload one file because of my company's proxy strategy. so if  possible , can you show me with one test file.

   many thanks for your help.

[SergeyMak]

Just post a data sample or at least copy small table directly to this window.

It's hard to predict your data.

Regards,

Sergey

[jagan]

Hi,

Please find attached file for solution, I used conditional option to show/hide the reference line using

Chart Properties-> Presentation -> Reference Line -> Edit-> Show - Condtional option.

Regards,

Jagan.

[#6]

HI Sergey

Thanks for your reply and sorry for my delay, the data  is like the below table show

Time	201401	201402	201403	201404	201405	201406	Target
Critical	0.8	0.95	0.95	0.95	0.90	0.99	0.85
Major	0.95	0.95	0.95	0.95	0.95	0.95	0.70
Minor	0.98	0.98	0.98	0.98	0.98	0.98	0.85
Others	0.99	0.99	0.99	0.99	0.99	0.99	0.65

when i set the chart time as the Xaxis ,and level as the YAxis, so the chart will has four value line , now i add four reference line as target line , now i want to when i check the critical level , only its value line and its target will show, other line will not display.

many thanks for your help.

[SergeyMak]

Hi,

PFA an example.

You can do same for others.

Regards,

Sergey