Background color in a Pivot Table

[brf10043]

I applied the background color coding below to a dimension in a pivot table.  However, when the dimension is not expanded the color defaults to Green " RGB(69,234,21)".  Is there any way around that happening?  I would prefer that there is no color coding applied until the dimension is expanded.

=If(Only(Priority_Factor) = 'High', RGB(255,0,0),
If(Only( Priority_Factor) = 'Medium', RGB(255,217,47),
RGB(69,234,21)))

[sunny_talwar · Accepted solution]

May be this:

=If(Only(Priority_Factor) = 'High', RGB(255,0,0),
If(Only(Priority_Factor) = 'Medium', RGB(255,217,47),
If(Only(Priority_Factor) = 'Low', RGB(69,234,21))))

[rubenmarin]

Hi Bobby, maybe it's because there are more than one value for Priority_Factor so it returns Null() and goes to the default, try adding a check for null, ie:

=If(IsNull(Priority_Factor), RGB(255,255,255), //change to standard bg color

If(Only(Priority_Factor) = 'High', RGB(255,0,0),
If(Only( Priority_Factor) = 'Medium', RGB(255,217,47),
RGB(69,234,21)))

[brf10043]

Once again!  Thanks Sunny