Forum Discussion

asbpowerbi's avatar
asbpowerbi
Helper IV
3 years ago
Solved

Field list column formatting

Hello All,     I have created a field list called OrderStatusFieldList. I need to format the background color of one of the fields in the list, based on the value in a measure.   Here is how I cr...
Need Help
  • mlsx4's avatar
    mlsx4
    3 years ago

    Hi asbpowerbi 

     

    Not sure if this is the problem but, you may need to include the sharp before the colour

    OrderNum-ColorCode =
     VAR flag = SELECTEDVALUE(Orders[OrderFlag])
     Return Switch(flag, "E", "#C24954",
                         "P", "#C24954",
                         "A", "#F4944D",
                         "R", "#F4944D",
                         "M", "#F4944D",    
                         "D", "#335668",
                         "C", "White",

     

mlsx4's avatar
mlsx4
Memorable Member
3 years ago

Hi asbpowerbi 

 

Not sure if this is the problem but, you may need to include the sharp before the colour

OrderNum-ColorCode =
     VAR flag = SELECTEDVALUE(Orders[OrderFlag])
     Return Switch(flag, "E", "#C24954",
                         "P", "#C24954",
                         "A", "#F4944D",
                         "R", "#F4944D",
                         "M", "#F4944D",    
                         "D", "#335668",
                         "C", "White",