Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to 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
@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
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
54 |