Line Chart do not draw if value is 0

Dashboard Designer SharePoint 2013/2016, Office 365 versions
1

Hi,

My current line chart has some 0 as value. Instead of drawing a dot at 0, is it possible to to remove that point all together? See chart for 1991, I'd like the orange line start at 1996.

My data item looks like:

[code]14:35:19 DEBUG - {

_events: [object Object],
Date: Tue Dec 31 1991 00:00:00 GMT-0800 (Pacific Daylight Time),
DwellingUnits: 2500,
Employment: 0,
Municipality: Electoral Area A,
MunicipalityId: 21,
_Municipality: [object Object],
Population: 7500,
PopulationType: Actual,
Year: 1991,
[/code]

Thanks.

Plumsail Dashboard Designer 2016-07-26 14-35-37.png955×342 25.3 KB

2

Hi,
Just replace 0 with null via JavaScript and you will get exactly what you need.

3

Hi,

I’ve set the value to null and it still drew 0.

In my dashboard -> advanced

config.series[0].data[0].Employment = null;
4

I suppose it should be:

config.series[2].data[0].Employment = null;
5

Thank you for pointing out I was updating the wrong series. This worked.