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 ...
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 🙂