Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

Conditional formatting expense vs income

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.




Frequent Visitor

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..

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors