Chart with data of virtual columns sets blank/error values to "0" instead of "blank"

Dear Community,

I have the following questin:
I have created a chart that. The values for it are calculated within a 30 virtual columns.
Currently if there calculated value is not a figure (for example “–”, or blank “”) the value of each data is shown/set to “0”.

3X_9_7_97018c82653bdac4eae66721ada60c068adca693.png

But i would rather have just a blank instead, like here. Unfortunatelly it seems like it just works with physical (real) columns, not virtual ones.

3X_3_2_322b2a9f37f63a3b656bddb3fcc18c7272a92ecc.png

I have tried with decimal("") or just “” or " " to reach the same result within the chart that gets its data out of the virtual columns but it didn’t work. (Unfortunatelly it seems like working with “show if” doesn’t work too, as in my case there are also more than one set of data within a chart.)

3X_f_1_f1b1b8c03f01b60969d3285dcab7e527ae945653.png

Appreciate help

1 5 512
5 REPLIES 5
Top Labels in this Space