Line Chart - do not display zeros

[jerryr125]

Hi - I have a line chart with the dimension of 'day' (autocalendar) and the amount as a measure.

How do I NOT display dates on the chart with the value of zero ?

Jerry

[bing_jville]

Use an IF statement in the expression of that measure - change it to NULL if it is 0

[Channa · Accepted solution]

use supres Null in dimension limits property

[jerryr125]

Hi - this solved the issue! Thank you 🙂 Jerry