Conditional Color Coding to a chart

Question & Answer
, , , , ,
1

I want to show color code apply automatically to the gauge chart & Other Charts well

image
image638×132 8.28 KB

image
image350×242 8.12 KB

Hi, i want to apply color code based on another values
Example: On time Delivery for the Mar/4/2025 is 76%

Green Color: if the On time Delivery is >=95%
Red Color: if the On time Delivery is <80%
Yellow Color: if the On time Delivery is >=80 && <95%

( May be the values in Target, Red columns will change )

How it can be done in Quicksight?

2

Hi @Venkat.Metadata,

You can apply conditional formatting to the gauge chart, KPIs, Pivot tables and tables.

See my example for a gauge chart below:

image
image1093×452 35 KB

Then you can edit the foreground colours with rules such as:

image
image227×783 21.1 KB

Let me know if this helps.

Many Thanks,
Andrew

3

Hi @Venkat.Metadata,
It’s been awhile since last communication on this thread, did you have any additional questions or did the solution provided above help with your case?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @Venkat.Metadata,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!

5

Thanks @abacon. It would be helpful. But I have 2 measures.
If i have 2 measures A & B ( the values will change in A & B Periodically ).

i have a scenario to apply conditional formatting based on

If A<B, Red,
if A=B, yellow,
If A>B, Green. ----- is this possible in QS.