Color Null Value for Dimension - Variable

[brettaustin]

Hello People... 

Basic color question.  I have dimensional data with 'Null Values'.  I want to color my chart based on the dimensions.  I created a variable to color code it, however I can not seem to assign a color to the 'Null Value'  RGB (150, 150, 150) - I do not want black.   Any ideas?  See attached for example

[sunny_talwar · Accepted solution]

May be load your data like this
If(Len(Trim(CurrentStatus)) = 0, ' ', CurrentStatus) as CurrentStatus,

and change the color to this
pick(match(CurrentStatus,
'BC0','BC1','BC2','BC3','BC4','BC5')+1, RGB (150, 150, 150),
rgb(239,149,149),rgb(239,218,149),rgb(185,231,149),rgb(149,231,235),rgb(149,158,239))

[brettaustin]

Thank you!  Great solution!