The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
80 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |