How to do Color coding ?

[Anonymous]

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

[Anonymous · Accepted solution]

@Anonymous 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.

[Anonymous · Accepted solution]

@Anonymous 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.

[Anonymous · Accepted solution]

Thank you @Anonymous, it worked out