Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Maybe one of these:
Add-ons > Data handling > Include zero values (deselect)
or
IF(Measure > 0, Measure)
Maybe one of these:
Add-ons > Data handling > Include zero values (deselect)
or
IF(Measure > 0, Measure)
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
Glad it works.