Forum Discussion
Conditional Formatting for +ve and -ve value
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 |
Hi Anonymous
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 02. Do the same with the second category
Result:
Please consider Accepting it as the solution to help the other members find it more quickly
1 Reply
Hi Anonymous
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 02. Do the same with the second category
Result:
Please consider Accepting it as the solution to help the other members find it more quickly