Conditional Formatting Matrix Columns

[Anonymous]

I have a Financial Statment matrix that compare Real vs Plan in  Revenues and Cost. In my Financial Statement Revenues are negative and Costs Positive.

I've also a column, Delta, that divide Actual Values by Plan Values as bellow (this was done in Excel):

How can I format the Column Delta with the right colours depending if is Revenue or Cost?

Thanks in advanced

[Vvelarde · Accepted solution]

@Anonymous 

Hi, you can use a measure to evaluate the positive/negative and the Type (Revenue or Cost)

ColorFormat =
IF (
    SEARCH ( "REVENUE"; SELECTEDVALUE ( 'Table'[Type] ),, 0 ) <> 0,
    IF ( [Delta] > 0, "#008000", "#ff0000" ),
    IF ( [Delta] > 0, "#ff0000", "#008000" )
)

After that In Conditional Formatting, Select Format By Field Value--Based on Field - ColorFormat

Regards

Victor