Create Bar graph Report with field values colors-Display colors only what colors field values have--Priority based

[Kishore8]

here i have one field Overall status,

Overall Status   Red, Yellow, Green.....so when i select Red-option field value comes to Red color.

                                                                                                                        so when i select Yellow-option field value comes to Yellow color.

                                                                                                                        so when i select Green-option field value comes to Green color

if you see report     option Green ---having blue color, so instead of   Blue ,   i want to show Green color

if you see report     option Yellow---having Green color, so instead of   green     , i want to show Yellow color

[darius_koohmare · Accepted solution]

Hi!

In the report builder, select use color palette.

Then in the set palette field, go to the lookup.

In the list view that opens, press the new option.

Define a new color scheme with jsut three colors, Green, Red, Yellow (in that order). The order in my screenshot is off.

Select it in the report color palette picker Then you will be set!

[Josh Cooper]

The challenge you run into here is that the first option will always be red (or green) regardless of whether there's a value or not - so in the example that you set your colors to red amber green, but Red = 0, then Yellow shows as Red.   Or if you have no Red or Yellow, then "Green" will be in Red.

It's a limitation of the platform.   There's a chance of a workaround where you can set a value to a decimal that rounds off to zero, in which case it's a non-null value so it will be displayed and 'consume' the color, but the value displayed will be zero due to rounding.

[Kishore8]

Hi Josh,

I am very happy with your detail explanation , thanks...

[Kishore8]

Hi Darius,

Thanks for your replay and sorry for my deplay replay..

i tried with your instructions now it is working fine , but here if set the condition in report again colors are changing there faces..

ex: with out conditions:     Yellow shows---------> yellow

                                                                                Red shows---------> red,

                                                                                Green show----->green,

if i set the conditions in report colors are changing there faces,

        with conditions:                                                                           yellow---->red

                                                                                                                                Green----->yellow

                                                                                                                                    Red------->Green

Is there any permanent solution for it.