Conditional formatting gives in correct values.

[puneethjp]

Hi, 

I am trying for the below scenrio: 

If KPI delta is greater than zero then green traingle should point green. ( value is in percentage)

If KPI delta is less than zero then red traingle should point red. ( value is in percentage)

Negative values should be red and positive in green

Thank you for your time and help. 

Thank,

Puneeth

[Ritaf1983 · Accepted solution]

Hi @puneethjp 
promo price seems like the number.
try to change the condition to "number " instead percent.
( use 1 as 100%)
+
Your conditions are the same both less than 100%....
Check it again.
Or 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot), and the wanted result, I will show how to create a needed condition.

[Ritaf1983 · Accepted solution]

Hi @puneethjp 
promo price seems like the number.
try to change the condition to "number " instead percent.
( use 1 as 100%)
+
Your conditions are the same both less than 100%....
Check it again.
Or 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot), and the wanted result, I will show how to create a needed condition.

[puneethjp]

Hi, 

Hi @Ritaf1983 We only have one column which is KPI delta. Do not consider the other value which is a number. So, for the column which is delta column which has values in percentage. I just to add a conditional formating. where when the percentage value is above 0 is should be green. When less than 0 (negative values) is should be red.

[Ritaf1983 · Accepted solution]

Hi @puneethjp 
As I mentioned use the "Number" option to format, with some huge unreal numbers on a minimum of the first condition and a maximum of a second.
It will work:

A more elegant way is to use flag measure :

more elegant way flag = if('Sheet1'[percent for formatting]>0,1,0)

and use it in formatting:

Sample file with both options 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[puneethjp]

Thank you so much. It helped.

[Ritaf1983]

@puneethjp 

Glad to help 🙂