Need to put a condition on 'suppress zero-values' option

[Sasik]

Hi All,

I need to hide the highlighted part in the below chart.

If I use 'suppress zero-values' option I can achieve this but initial part of the line (0 to 42% line) is not displaying as the starting value is zero. Somebody please help how can I avoid the highlighted dates and preserve the initial line.

This looks like below when I convert to straight table.

Please help to resolve this.

Regards

SasiK

[edwin]

try setting SUPPRESS MISSING to ON

[Sasik]

Hi Edwin,

Thanks for your reply, I tried this already. Even turning 'Suppress Missing' ON or OFF no change is happening to the chart.

Regards

SasiK

[kamielrajaram]

Hi ,

Try Suppress Null values on date dimension with suppress 0 values unchecked

Regards

Kamiel

[Sasik]

Hi Kamiel,

Chart is not responding for this option. Chart is responding only for 'Suppress zero values'. But this option treating zeros and nulls as same. 

Regards

SasiK

[Brett_Bleess]

It would likely be most helpful if you can attach the QVW, so folks can look at things in further detail if you still require further assistance.

Regards,
Brett