How to leave the missing value as a gap in Combo Chart?

[isaaclin]

Could someone help me to figure out on remove those drop lines in a combo chart?

I tried the chart option to leave the missing value as a gap, but it didn't work.

Thank you in advance.

[Ivan_Bozov · Accepted solution]

Maybe one of these:

Add-ons > Data handling > Include zero values (deselect)

or

IF(Measure > 0, Measure)

[isaaclin]

Thank you Ivan for the quick response and the correct answer.

the option 2 works for me for my case, but I believe the option 1 could work, if I convert the null into 0 in my load script.

Thanks again.

Isaac

[Ivan_Bozov]

Glad it works.