Custom Formatting

[Pklu]

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.

[ArwaAldoud]

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.

[Karuppasamy8708]

Is it possible to keep the formatting in excel while exporting in workspace?

[jdbuchanan71 · Accepted solution]

Is your variance amount from a measure?

You would just apply the rules like this to the background of the Variance field:

[jdbuchanan71]

@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

[Pklu]

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