How to do Color coding ?

[Bhaveshp]

Hello, 

I have the column 'Flag' in my table which says Yes/No for the jobs run. 

For Flag with 'Yes' I need to show Green color

For Flag with 'No' I need to show Red color

Please help in write the DAX formula for that? 

thank you 

Bhavesh

[Seth_C_Bauer · Accepted solution]

@Bhaveshp You can accomplish this without DAX, or the only DAX would be to switch your "yes" to 1 and your "no" to 0. Then right click on the field name and use conditional formatting for value and background for a table or matrix.

[Seth_C_Bauer · Accepted solution]

@Bhaveshp You can accomplish this without DAX, or the only DAX would be to switch your "yes" to 1 and your "no" to 0. Then right click on the field name and use conditional formatting for value and background for a table or matrix.

[Bhaveshp · Accepted solution]

Thank you @Seth_C_Bauer, it worked out