Forum Discussion

Kalachuchi's avatar
Kalachuchi
Icon for Helper III rankHelper III
5 years ago

Change background color depending on current value

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" )

 

Need Help
Tutorial Requests

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Kalachuchi 

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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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