This content has been marked as final. Show 2 replies
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.