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

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.

Reply
romoguy15
Helper IV
Helper IV

Change font color of value based on condition using Dax (Red, Yellow, Green) in Power KPI Matrix

Hello,

 

I am using the Power KPI Matrix visual and I am trying to change the font values of one of my columns based on a condition statement. The colum days to target needs to be in a font color of Red, Yellow, or Green based on specific numbers. I've pasted below a link to the report with some additional information regarding the format. I tried to test this on a table and created a few dax measures to see if it could work but I failed to figure out the error in the conditional formatting.

https://1drv.ms/u/s!AqID1H0nHPOzg3Ui9ufWS0M9ix3v?e=bS606Z

 

Thank you in advance for any help on this.

2 REPLIES 2
romoguy15
Helper IV
Helper IV

@lbendlin Thanks for the reply. So it looks like the publisher is Microsoft. I posted the idea here. Hopefully it is in the right spot.
https://community.powerbi.com/t5/Custom-Visuals-Ideas/Power-KPI-Matrix-Conditional-Formatting/idi-p/...

 

I wanted to mention, I got the conditional formatting based on field value to finally work. I had a double pipe symbol in my Days to target status measure that caused it not to work. Once I removed that. It worked perfectly. So basically you are saying without the conditional formatting available in this custom visual, what I am trying to accomplish cannot be done?

lbendlin
Super User
Super User

You are using a custom visual. Ask the visual developer if they can add conditional formatting.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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.