Fixing a color for "Others"

[ninnartx]

Hi everyone,

I have fixed colors for my products (using RGB values loaded from excel + Background Color in expression). It works fine until i added a dimension limit - "Show only values that are greater than 5% relative to the total". The rest are shown under "Show Others".

Right now "Others" is black. I would like to change it to a different color. I understand that normally the color for "Others" can be determined under the Colors tab; but since I have fixed Background Color, changing the color under the Colors tab didn't work. I've tried to add Others into my excel sheet but that didn't work either.

Is there a way to fix a color for "Others" when you have defined RGB values for that field/dimension?

Thank you!

[rubenmarin · Accepted solution]

Hi Ninnart, you can try checking if there is only one color to set that color or the default, like:

If(IsNull(ColorField), $(vDefaultColor), ColorExpression)

vDefaultColor can be variable with the default color.

[ninnartx]

Thank you!!!