Zero values in charts

Dear Community

I have a chart with development of KPI over months. The user has the possibility to select different years. The Serie is plotted as a line.

Now I have the problem, that when the values of past years is zero, the line has a break in between and the chart is strange.

so I want to deactivate the "zero value" option. But with that, in actual year for all coming months a 0 is shown in the table. Which looks poorly too. As we want to show development in future of budgets the actual year should display all months.

Anybody has a workaround for this? Or am I missing something?

I only figured out to show values as blocks.

Hint: the KPI can be very low, i.e. 0.01.

Best

Manuela

Answers