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

Min and Max Color Formatter.pbix18 KB

Mathematical

Other

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 🙂

Min and Max Color Formatter.pbix22 KB