- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Suppress Missing not working with color function
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How about using a calculated dimension via the ColorAbove formula to determine if the Org group dimension should be displayed?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sounded good, so I tried it. It just replaced the label with "-" ... still showing the missing value. Too bad.