Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
ArchStanton
Impactful Individual
Impactful Individual

Conditional Formatting Rule doing the opposite of what it should

Hi,
I am using some Rules based conditional formatting that works for the 19.7% figure you can see in the Card visula below (<20% is Green otherwise Red) but doesn't work for the Border which shows red for under 20%. I have had to reverse the rule in order to make the border Green in the visual below.
Can anyone explain why this maybe happening?

ArchStanton_0-1764325732212.png

 

ArchStanton_2-1764326562207.png

Thanks

1 ACCEPTED SOLUTION
Zanqueta
Continued Contributor
Continued Contributor

Hi @ArchStanton, let me contribute

 

Try create a measure that returns a colour code:

BorderColor =
IF([YourMeasure] < 0.2, "#00FF00", "#FF0000")

 Then apply Field value conditional formatting to the border using this measure. This avoids interpretation issues.

 

 

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

View solution in original post

3 REPLIES 3
Zanqueta
Continued Contributor
Continued Contributor

Hi @ArchStanton, let me contribute

 

Try create a measure that returns a colour code:

BorderColor =
IF([YourMeasure] < 0.2, "#00FF00", "#FF0000")

 Then apply Field value conditional formatting to the border using this measure. This avoids interpretation issues.

 

 

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

This is cool fix, thank you!

amitchandak
Super User
Super User

@ArchStanton , I saw the other post too, mean rulesare  working correctly on the outline. Can you share pbix to check 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors