Forum Discussion

RAHULBANDI's avatar
RAHULBANDI
Icon for Helper II rankHelper II
4 years ago
Solved

How to highlight the maximum and minimum value in a matrix

Hello,   I have following Data-set FISCAL YEAR     MONTH   SALE FY 19-20 JUL 850 FY 19-20 AUG 120 FY 19-20 SEP 630 FY 19-20 OCT 9910 FY 19-20 NOV 4250 FY 19-20 DEC 3...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    RAHULBANDI I created a color filter like below and used it in conditional formatting. See PBIX file attached below signature:

    Color Formatter = 
    VAR __FY = MAX('Table'[FISCAL YEAR])
    VAR __Value = SUM('Table'[SALE])
    VAR __Table = SUMMARIZE(FILTER(ALL('Table'),[FISCAL YEAR] = __FY),[MONTH],"__Sales",SUM('Table'[SALE]))
    VAR __Min = MINX(__Table,[__Sales])
    VAR __Max = MAXX(__Table,[__Sales])
RETURN
    SWITCH(TRUE(),
        __Value = __Max,1,
        __Value = __Min,2,
        0
    )

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

RAHULBANDI I created a color filter like below and used it in conditional formatting. See PBIX file attached below signature:

Color Formatter = 
    VAR __FY = MAX('Table'[FISCAL YEAR])
    VAR __Value = SUM('Table'[SALE])
    VAR __Table = SUMMARIZE(FILTER(ALL('Table'),[FISCAL YEAR] = __FY),[MONTH],"__Sales",SUM('Table'[SALE]))
    VAR __Min = MINX(__Table,[__Sales])
    VAR __Max = MAXX(__Table,[__Sales])
RETURN
    SWITCH(TRUE(),
        __Value = __Max,1,
        __Value = __Min,2,
        0
    )