Forum Discussion
Solved
Change background colour for table data
I've got a number of tables, with various results in the table. ie yes, no, not yet, not necessary I need to assign a colour to each (ie green for yes, red for no, amber for not yet, yellow f...
Hi lee-martin ,
1.You could use the following formula to create a measure and the apply it to Conditional Formatting:
Color Measure = SWITCH(MAX('Table'[Column1]),"yes","Green","no","Red","not yet","#FFBF00","not necessary","Yellow")2. Go to Format pane-->Disable "Total" to not show total field:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi lee-martin ,
1.You could use the following formula to create a measure and the apply it to Conditional Formatting:
Color Measure = SWITCH(MAX('Table'[Column1]),"yes","Green","no","Red","not yet","#FFBF00","not necessary","Yellow")
2. Go to Format pane-->Disable "Total" to not show total field:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.