This content is now out of date.

Visit Our Community

How to suppress missing values in charts

Hi Team ,

Please let us know how to suppress missing values in charts.

Currently in a multi dimension chart , if values are not present for a particular dimesnion value , its getting plotted at 0 . How to supress these values in Cross tab reports.

PFA the screenshot for the chart in which we want to supress zero/missing values

I found this Forum post regarding null-values and charts for your review.

Missing Values

Please let us know if this helps.

Thank you,


Hi Kyle ,

We wanted to supress null in metrics . The above example is to supress Null in dimensions..

In the attachment for year 2014 ,for several months the metric is null . But still since its a cross tab , its showing zeros for those months in the graph.

We want to supress those zero values . Please let us know how can we achieve this

Hi Sanjay,

What you're after is definitely possible.
You just need to disable the 'Nulls as Zeros' option on the column formatting for your measure.


Forum image

You will then end up with a cross-tab that shows nulls, rather than 0s.

Forum image

Please let me know if this doesn't give you what you were after.