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
Go to Solution.
Hi, you can use a measure to evaluate the positive/negative and the Type (Revenue or Cost)
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
Proud to be a Datanaut!
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.