Conditional formatting expense vs income

[khalid984]

Dear PBI community,

I am currently using conditional formatting in a matrix column on difference % of actuals vs budget. I am using the standard conditional formatting future stating -1 (-100%) is red and 1 (100) is green. However, i would like to distinguish between income and expense rows, so that for expense the opposite is true (-1 is green and 1 is red).

Would be great if any of you would have a solution for this.

KR,

Khalid

[lovermann]

I don't think this is a good idea, that you have in the same column data of green and red color and at the same time 70% can be green and on the line below 70% is red. I think you should rather distinguish it. From my point of view it is not user friendly approach at all..