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”.
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.)
Thank you fo reporting this. @Arthur_Rallu@benhare let’s look at this as we are touching this code… It’s weird that we are handling physical and virtual column differently. I think we need a proper option for handling null values, meaning treating it as a 0 or as a missing value and thus a line chart should join the two existing point and ignore the null position entirely. But that should be an option as Null may have different meaning semantically with different columns (Null as measure vs Null for a dimension type column)
ysical and virtual column differently. I think we need a proper option for handling null values, meaning treating it as a 0 or as a missing value and thus a line chart should join the two existing point and ignore the null position entirely. But that should be an option as Null may have
What I have recognized is, it may also depend on the formula of the column (maybe it is just not able to calculate sereval if-loops). If I just type “–” into the column formula it appears correct. But not with an bit of expression inside, like (shown value (absolute or relative) should depend the user button choice):
