Forum Discussion
Conditional formatting gives in correct values.
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
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.
OrPlease 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.
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:If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
5 Replies
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.
OrPlease 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.
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.
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:If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
