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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
L1394
New Member

undefined

Hello everyone, 

I am trying to write a dax measure to apply colors to chart based on employee performance. I have employee performance sorted for q1,q2,q3,q4 and also each employee have different targets. I was told to give green if they meet their target or else red. But the only issue is lets say emp1 could not able to meet his target in q3 so in the chart it should shown as q3 in red and rest in green. Let me know if anyone knows about it. Thanks in advance

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @L1394 ,

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Create a measure as below

Conditional formatting = IF ( SUM ( 'Table'[performance] ) >= SUM ( 'Table'[target] ), "green", "red" )

2. Toggle on the option "Data labels" and configure conditional formatting for it

vyiruanmsft_0-1698902368772.png

Best Regards

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @L1394 ,

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Create a measure as below

Conditional formatting = IF ( SUM ( 'Table'[performance] ) >= SUM ( 'Table'[target] ), "green", "red" )

2. Toggle on the option "Data labels" and configure conditional formatting for it

vyiruanmsft_0-1698902368772.png

Best Regards

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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