Forum Discussion
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 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
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",
1 Reply
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",