Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have an application where I use a variable to change which expression will display in a particular chart. I also use a color function to change the color of the bars depending on a goal. Adding this seems to override "suppress missing" under presentation. I can't use suppress zero because for some expressions, zero is a valid result.
I tired using If() instead of sets and that didn't work.
This sheet demonstrates what I mean. The charts are the same except for the color function... the one without the color function works but the one with does not.
Ideas?
Thanks!
How about using a calculated dimension via the ColorAbove formula to determine if the Org group dimension should be displayed?
Sounded good, so I tried it. It just replaced the label with "-" ... still showing the missing value. Too bad.