Min/Max Color Formatter 09-25-2022 19:02 PM

[Greg_Deckler]

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
    )

eyJrIjoiYzhiMWQyYjAtMWI4NS00ZTVhLTljMzktMjRmYjNkZWZmMzM3IiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9

[Aysh_2104]

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 🙂