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.
I have 2 columns on A & B
based on the 2 columns i have created 2 calculated measures

AA - Average of A column for the last 3o days
BB - Average of B column for the last 3o days

i have a scenario to apply conditional formatting based on

If AA<BB, Red,
if AA=BB, yellow,
If Aa>Bb, Green. ----- is this possible in QS.

6

@Brett & @abacon , Pls help for the above Question

7

@abacon , here we are giving the static values which are fixed.

But i want to have a conditional based on the dynamic values of a calculated measures like in Power bi.

I mean, we can compare 2 measure & based on the we can give color coding.

like this

ifelse(

{Yesterday Scrap Value} < {Yesterday Scrap Value Target}, ‘Red Color’

{Yesterday Scrap Value} >= {Yesterday Scrap Value Target} AND {Yesterday Scrap Value} <={Yesterday Scrap Red Value}, Yellow Color

{Yesterday Scrap Value} > {Yesterday Scrap Red Value}, Green Color

)

8

Hello @Venkat.Metadata

You can accomplish something similar to your calculation above with QS but you would need to use integers rather than “red colour”.

There is not currently a way to directly compare two field values for conditional formatting.