Change background color depending on current value

[Kalachuchi]

I have 27 columns that needs to have color on it's value I am using a measure for each column (QRM_1) but I still have 26 more to. is there any workaround  to do this?

Color Codes = 
    VAR QRM_1 = SELECTEDVALUE(FactTable[QRM_1])
    
    RETURN Switch(QRM_1,"Gold Standard","#ffc000","Almost Always","#92d050","Usually","#999999","Often","#fff2cc","Sometimes","#ff0066","Rarely","#ff0000","Never","#ECF0F1" )
    

[Anonymous]

@Kalachuchi 
In you case, I cannot think of any workaround, you cannot do conditional format unless you have all values in one field.

Paul Zheng _ Community Support Team

[pranit828]

Hi @Kalachuchi 

I am afraid not as the conditional formatting can be done on each column seperately.