Forum Discussion
Custom Formatting
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?