Conditional Formatting for +ve and -ve value

[Siddharth_2987]

Hi Team,

I am new to PowerBI, I am trying to get conditiional formatting for +ve and -ve value. I tried but not understanding the error.

Attached is the data through which Bar chart I have prepared and the conditional formatting logic I have used.

I need support to get the proper result.

	Cat1	Cat2
A	-0.9	0.8
B	0.4	-0.3
C	-0.2	0.6
D	-0.3	0.7

[Ritaf1983 · Accepted solution]

Hi @Siddharth_2987 

You need to modify the condition for every category separately and use "numbers" instead of percentages.
Please follow these steps :
1. For category 1 modify the rule based on a greater than some huge negative number and less than 0 

2. Do the same with the second category

Result:

Link to the sample file 

Please consider Accepting it as the solution to help the other members find it more quickly