Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Min/Max Color Formatter

Here's a simple method to mark minimums and maximums using conditional formatting.

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
    )

Mathematical
Other

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for the quick reply Greg_Deckler . I have a sample attached in PBI same as your example.

     

     

    Count of sales and sum is a one measure of switch, where in this i want only sum to have conditional formatting not the count. Also i need conditional formatting to be done based on the fiscal year. each fiscal year has different criteria. Below is an example for criteria

    Thanks for the help in advance 🙂