Forum Discussion
Solved
Custom Formatting
I have a table with the following fields and values: Projected Amount Actual Amount Varience $45 $50 -$5 $150 $50 $100 $400 $600 -$200 $165 $200 -$35 $75 $50 $25 ...
Is your variance amount from a measure?
You would just apply the rules like this to the background of the Variance field:
Pklu ,
You can apply conditional formatting to the field based on the value like this:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
I tried all that. They were the first things I did but it did not meet my expectations.
Looking for something like this:
| Projected Amount | Actual Amount | Varience |
| $45 | $50 | -$5 |
| $150 | $50 | $100 |
| $400 | $600 | -$200 |
| $165 | $200 | -$35 |
| $75 | $50 | $25 |
| $450 | $500 | -$50 |
To this