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
-
Hello @Manuela Jucker,
are you referring to "Differentiate zero and null" or "Hide zeroes"? Did you remove the show all option?
0