Forum Discussion

CLANG10's avatar
CLANG10
Helper I
3 years ago
Solved

Color highest value in a table column

Hi,      I wanted to insert background colour for highest value (i.e. 386) in a table column. Wrote a measure "COLOR MAXCT" and apply in field value formatting, but the results colour all rows in th...
Need Help
  • Arul's avatar
    Arul
    3 years ago

    CLANG10 ,

    try this measure,

     

    COLOR MAXCT = 
VAR _max = MAXX(ALLSELECTED('Tablename'),'Tablename'[VALUE])
RETURN IF(_max = MAXA('Tablename'[VALUE]),"#E6007E")

     

    Thanks,

    Arul

Arul's avatar
Arul
Super User
3 years ago

CLANG10 ,

try this measure,

 

COLOR MAXCT = 
VAR _max = MAXX(ALLSELECTED('Tablename'),'Tablename'[VALUE])
RETURN IF(_max = MAXA('Tablename'[VALUE]),"#E6007E")

 

Thanks,

Arul