Forum Discussion
Conditional Formatting
Hi all, I want to ask why my conditional formatting is not working. This is my matrix and the conditional formatting. The orange arrow should be in green as it exceeds 15%. Thank you so much. ...
Anonymous
try to compare with Number, not Percent
Yes it is a measure field. Here is the formula and yes I do use the CALCULATE() function. GP YTD and GP LY also are measure field.
Green arrow stopped at 100% btw.
GP Growth % = if(and([GP YTD] =0,[GP LY]=0),0,if(and([GP YTD] >=1,[GP LY]=0),1 ,if(and([GP YTD] =0,[GP LY]<=0),1,if(and([GP YTD] <=-1,[GP LY]>=0),-1,if(and([GP YTD] >=1,[GP LY]<=0),CALCULATE(([GP YTD]-[GP LY])/-([GP LY])),CALCULATE(([GP YTD]-[GP LY])/[GP LY]))))))
Anonymous
I see values 154% and green arrow. I dont see any rules which describes >100% case.
So, I sure the problem is in measure interpretation.
Show data example, GP YTD and GP LY statements
are you sure you dont use any additional aggregations?
az38there is no way we can put >100% condition as Power BI doesn't allow that. The logic allowed is between 0 to 100%. That's why I put the number in the condition to make negative percentage becomes red arrow. Here is some of the data sample for GP YTD and GP LY.