Highlight minimum Value in Matrix

[Guneet_B21]

Hi,

i am trying to create a matxir using which i can identify the least time taken and by which carrier on every different tradelane (origin and destintation)

Kindly help me out with this situtation

[TomMartens]

Hey @Guneet_B21 ,

what exactly is your question, I can see there are two icons flagging the minimum values in the matrix, does this mean the problem is already solved.

Minimum for every tradelane, why is this important? Both columns are part of the matrix is there anything wrong with the design of the matrix, meaning with the expected results.

Please try to elaborate.

Regards,

Tom

[Guneet_B21]

Hi Tom,
the ones which already have icon flagging are just an example how i wanna show the data,

i wanna highlight the lowest transit time and which carrier provided that like in the above screenshot

[v-rzhou-msft]

Hi @Guneet_B21 ,

I suggest you to try code as below.

Conditional formatting = 
VAR _MIN = MINX(FILTER(ALL('Table'),'Table'[Origin] = MAX('Table'[Origin])),[Transit])
RETURN
IF(SUM('Table'[Transit]) = _MIN,1,0)

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Guneet_B21]

Hi @v-rzhou-msft ,
thanks for this solution, it seems to be working

However it is still leaving some blanks.

kindly help out with this if possible