Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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?
Thanks
Solved! Go to Solution.
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 🌀.
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!
@ArchStanton , I saw the other post too, mean rulesare working correctly on the outline. Can you share pbix to check
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!