09-25-2022 22:12 PM
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 )
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 🙂