Change empty fields to blank

[#1]

Is there a way to show empty fields in a straight table chart as blank instead of the '-'? I know you can do an if-else-condition in the expression, but with over 100 columns that would be a lot of manual work. Any easier way to accomplish this?

[sunny_talwar]

You can do this:

If(Len(Trim(Field)) = 0, ' ', Field)

[tamilarasu · Accepted solution]

Hi Daren,

Chart Properties -> Presentation Tab -> Replace the hyphen in null symbol and missing symbol by space.

[#4]

Do you put this in every single expression?

[#5]

Thanks Tamil that works!