Report not showing correct color if the value is NULL, Shows the correct color if value is Not NULL

[claires]

This report is going to be on a management dashboard and needs to show the correct color even if the value is null.  The legend looks bad. This is a multi data set report.  1) red, 2) green, 3) red, 4) green.  We played with all kinds of color combinations.

Each of the colors are set individually.

[AnveshKumar M]

Hi @claires 

Navigate to All > Reports > Administration > Chart Colors

Then see the color definition created for the table, element (field) and value combination.

I hope you can override this bahviour from here.

Please mark my answer helpful and accept as solution if it helped 👍✅

[AndersBGS]

Hi @claires ,

To ensure that the colors are consistent no matter value or not, you should utilize the report chart color

Here you will be able to set a specific color based on the table, element and off course the specified color:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[claires]

What do I put where the value is a date? 

If it is blank I said "NULL" for the number field.

Thank you!