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 the column instead. Seek advise on how Measure should be written to correct this. Thanks!

 

 

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

2 Replies

  • 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

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago
    VAR MAXCT = MAXX(Al('таблица'),[VALUE]) RETURN IF(MAX('table'[VALUE])=MAXCT,"#E6007E")