Exclude empty values from line chart

[percarlen]

I'm using a linechart where the X-axis are dates and the Y-axis are decimal values. These decimal values are shown as 0,0 on the chart even if they are missing. Setting initial value to "" does not help.

How do I solve this other than setting the initial value to some arbitrary text string, which works but have negative side effects?

[percarlen]

Anyone, please? 😫 This is the final piece before I can deploy my app.

[Steve]

Create a slice on the table that excludes the unwanted rows. Use the slice for your chart view.

[percarlen]

I found a workaround where I use a virtual column that converts the values ​​to an arbitrary text string. In this case I used "NULL" but "MONKEY" works just as well.

IF(IsBlank([RealValue]), "NULL", [RealValue])

Isn't there a way to just have the chart treat non-existing values for what they are? 0,0 is not an empty value.

[Steve · Accepted solution]

---

Isn't there a way to just have the chart treat non-existing values for what they are?

---

Nope.