Conditional formatting on columns does not work correctly

[Ausar]

Hi everyone,

Could someone tell me why conditional formatting works incorrectly?

• Value between 0 and 5: green color
• Greater than 5 and less than 10: light red
• Above 10 and below 100: red
  

[Ausar]

@Syk @Kaviraj11 

Nothing changed. Same issue

[Kaviraj11]

Can you show what measure did you use in the chart? Need to understand the calcualtion behind that. 

[Ausar]

[Kaviraj11]

Hi,

It seems like you have the mismatch unit in the condition as shown below. Please correct it with unique and single unit either Number of Percent.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Syk]

Try switching all of the selection boxes to % instead of number.

If value >= 0 Percent and <= 5 Percent then green