Forum Discussion
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...
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.
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