Stagnant Trget lines?

[divya_anand]

Hello everyone,

I have a question regarding the target lines. Is it possible to have the target lines stagnant?

I have a combo chart with 2 dimensions and 1 expression. Additionally I have 5 more expressions which would depict the 5 target lines. (The line doesn't show when I use "Reference Lines", hence I use expressions).

Is it possible to have the target lines that doesn't change with selections? For eg., when I have NO selections made I have the Chart1. And when I make a selection in a particular field I end up with Chart2. But the expected chart when I make a selection should have the same target line as in Chart1 and the bars as in Chart2. Is this possible? If yes, How?

Chart1:

Chart2:

[Gysbert_Wassenaar · Accepted solution]

Add {1} to the expression for the line so that it ignores all selections. For example if that expression is sum(Target) change it to sum({1}Target).

[divya_anand]

Works perfectly for me, Thank you very much.