Reply
avatar user
Anonymous
Not applicable

Conditional Formatting Matrix Columns

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):

Screenshot_1.png

 

 

 

 

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

Thanks in advanced

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@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

 

img3.png

Regards

 

Victor

 




Lima - Peru

View solution in original post

1 REPLY 1
Vvelarde
Community Champion
Community Champion

@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

 

img3.png

Regards

 

Victor

 




Lima - Peru
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)