Forum Discussion
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 |
| $450 | $500 | -$50 |
I would like to have all the negative variences column background - RED and all the postive variences column background - GREEN.
Is your variance amount from a measure?
You would just apply the rules like this to the background of the Variance field:
5 Replies
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-formattingI 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
Is your variance amount from a measure?
You would just apply the rules like this to the background of the Variance field:
Hi Pklu
Since you only have two options (negative or positive), you can achieve this using a Color measure and applying it in Conditional Formatting:
- Go to Conditional Formatting → Background Color.
- In the "What field should we base this on?" section, choose Color.
- Use this measure:Color =
SWITCH(
TRUE(),
ISBLANK(SELECTEDVALUE('Sheet1'[Varience])), "Gray",
SELECTEDVALUE('Sheet1'[Varience]) > 0, "Green",
SELECTEDVALUE('Sheet1'[Varience]) < 0, "Red",
"Gray"
)Check the screenshot for more clarity
If this response was helpful, please accept it as a solution and give kudos to support other community members.
Is it possible to keep the formatting in excel while exporting in workspace?
