Conditional formatting combining 2 value.

[goyalsa]

Hi all,

I want to apply color conditional formatting using 2 value.

If Cost per Order value is minimum for a particular month and for the same month the count of order if is maximum then both value shows in green otherwise red.

Kind regards,

Sahil Goyal

[goyalsa]

Hi, Any help would be really helpful

[olgad]

Hi, create a measure with the condition of yours and add that measure to conditional formatting "color by field"

[goyalsa]

Hi @olgad 

I want only to highlight the minimum cost per order row wise. I was trying this measure but not giving me what I want.

Highest value =
VAR Maxprice = CALCULATE(MAXX(Merge1,[Cost per Order(USD)Ferry laden.]))
Var Result =
IF( [Cost per Order(USD)Ferry laden.] = Maxprice, "GREEN")
RETURN Result