Zeros in pivot table and charts but surpress when value is null is unchecked

[tinkerz1]

Hi,

I have no zeros in my pivot tables and charts but surpress when value is null is unchecked so I expected to see them?

I am using a crosstable import from excel.

Is there another setting?

Thanks,

Neil.

[tinkerz1]

Ok got it:

In presentation tab uncheck surpress zeros

In diminsion tab check surpress when value is null

[awhitfield]

Hi Neil,

there's this one on the presentation tab too!

HTH - Andy

[tinkerz1]

Thanks,

I wrote before I tested on a chart, maybe you can help here.

If there is a zero I want the dimension, like a date to plot, but of course no value will show up.

But if the value is null I dont want a plot either but I am getting them with.

So I am a bir lost as to why nulls are plotting but zeros are not

[giakoum]

most likely it has to do with your expressions and dimensions

can you post a sample app?

[tinkerz1]

I have a attached a QVW,

I want the zero to trigger having the date in the x axis but dont plot blank data.

The legend can stay on, this is to future proof a potential change.

[#7]

If you want to plot zero, uncheck the "Suppress zero" in presenation and if you don't want to plot the null value, check the "Suppress when null value" check box.

[giakoum]

Hi Neil.

from the sample app I can see that it works as expected. You do not have any missing data (no null values in field Data) only zero or above zero.

I am really not sure what the problem is. See the image below

[tinkerz1]

There is another line measure call amber threshold that is all nulls, does that not show iun the QVW.

This is the meaure that I want to future proof, if its null I dont want to show the line, is it on your chart?

[tinkerz1]

Ok so that looks like a table box.

So have I forced the pivot table and chart to do something when I do an expression

Sum({<Measure={'Amber Threshold'}>}Data)

But Amber Threshold is not there according to the table box, so SUM is ploting on the chart, but its an error?