Forum Discussion
Solved
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 t...
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
Best Regards
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
Best Regards