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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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