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 situtation

Need Help
Show and Tell

4 Replies

  • 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.