DAX: Background colours for whole row

LABrowne — Thu, 26 Oct 2023 13:56:27 GMT

Hello there,

I am working on creating a table of sales orders. Sometimes we have orders that have later been cancelled but show up on the orders table. Usually someone will log this info with the order name and at the end put "- Cancelled" e.g. Sarah Jane - Cancelled. This is so we can see which orders have been cancelled. If an order has Cancelled at the end of it I want the whole row's background color to be Red. This what I have so far:

Background Cancellation Colours =
IF ( MAX (Orders[OrderName]) = "Cancelled" , "Red", BLANK())

I believe I am going wrong because no order name is just "Cancelled" it's just apart of it if there is a contains formula it might work.

Any help would be great!

Kind regards,

Luke

Re: DAX: Background colours for whole row

FreemanZ — Thu, 26 Oct 2023 14:01:29 GMT

hi LABrowne ,

try like:

Background Cancellation Colours =

IF ( CONTAINSSTRING(MAX (Orders[OrderName]), "Cancelled") , "Red", BLANK())

Re: DAX: Background colours for whole row

LABrowne — Thu, 26 Oct 2023 14:18:50 GMT

Thank you very much!

topic Re: DAX: Background colours for whole row in DAX Commands and Tips

DAX: Background colours for whole row

Re: DAX: Background colours for whole row

Re: DAX: Background colours for whole row