Conditionally format percentage values in card visual

[djemy1975]

Hi colleagues,

I have a card visual displaying data in percentages .What I want is to display values in different colors on condition ,like that:
1 -When value is greater than or equal to -15% ----- font color "Red"
2- When value is less than -15% and greater or equal to -1% -----font color "Orange"
3- When value is greater or equal to 0% -----font color "Green"


I have played much time on color rules ,but in vain. Could someone give me the right choice.

Best regards,

 

[Switters123]

I'm not sure if card visuals have special formatting requirements, but here's one way to solve this with a series of conditional formatting rules.

First highlight the group of cells you want to format, then go into the conditional formatting function.
Here are the rules (I assume this is what you mean - LESS than or equal to -15%, right?)

=IF(K18>=0,"true","false") (set format to green and use the "stop if true" checkbox)
=IF(K18<=-15,"true","false") (set format to red)
=IF(K18<=0,"true","false") (set format to orange)

Here are some sample results I'm getting

 

[djemy1975]

I'm not sure if card visuals have special formatting requirements, but here's one way to solve this with a series of conditional formatting rules.

First highlight the group of cells you want to format, then go into the conditional formatting function.
Here are the rules (I assume this is what you mean - LESS than or equal to -15%, right?)

=IF(K18>=0,"true","false") (set format to green and use the "stop if true" checkbox)
=IF(K18<=-15,"true","false") (set format to red)
=IF(K18<=0,"true","false") (set format to orange)

Here are some sample results I'm getting
View attachment 35636

Hi Switters123,

My problem is related to POWER BI formatting rules and not excel

Thanks,