Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
15 | |
13 | |
11 | |
9 | |
8 |