Field list column formatting

[asbpowerbi]

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 created the field in the field list:

("OrderNumber", NAMEOF('Orders'[OrderNumber]), 0)

When I display the fields, it defaults to a table visual, I select the format cell elements and select the OrderNumber field. I then format the field based on the following measure: 

OrderNum-ColorCode =

     VAR flag = SELECTEDVALUE(Orders[OrderFlag])

     Return Switch(flag, "E", "C24954",

                         "P", "C24954",

                         "A", "F4944D",

                         "R", "F4944D",

                         "M", "F4944D",    

                         "D", "335668",

                         "C", "White",

The background color is not changing based on the value in OrderNum-ColorCode. I do not include the orderNum-ColorCode in my field list. Any ideas why the background color is not changing?

Cheers!

Peter

[mlsx4 · Accepted solution]

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