Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@Anonymous
try to compare with Number, not Percent
Hi @Anonymous
there are much more in Conditional Formatting dialog box, please show.
Bytheway, I see your last row has Number as Unit, not percent. Im not sure it will work correct
Hi @az38, here is the full conditional formatting dialog box. The number at the end of the condition does not affect the icon/colors even if I remove it. I've tried it before w/o the last condition and it still doesn't work. The only problem is the numbers greater than 15 are marked as orange icon while it should be green icon.
@Anonymous
what is [GP Growth %] field? is it a measure? do you use CALCULATE()?
and do you like green arrows in values like 900%? your rule should cut it off
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.
@Anonymous
could you remove sensitive data and share your pbix-file to cloud-service in order to help you?
@Anonymous
try to compare with Number, not Percent
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |