Forum Discussion

Guneet_B21's avatar
Guneet_B21
Helper II
3 years ago

Highlight minimum Value in Matrix

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 sit...
Need Help
Show and Tell
TomMartens's avatar
TomMartens
Super User
3 years ago

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's avatar
Guneet_B21
Helper II
3 years ago

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      Guneet_B21
      Helper II
      3 years ago

      Hi Anonymous ,
      thanks for this solution, it seems to be working

      However it is still leaving some blanks.

      kindly help out with this if possible