topic Highlighting the min & max values in a Power BI column chart in DAX Commands and Tips

Highlighting the min & max values in a Power BI column chart

carlosgeovany — Tue, 25 Jul 2023 13:33:17 GMT

Hello,

I'm trying to highlight the max and min value from this chart:

To this:

I tryed using formating colors based on DAX measures like this:

Weekday = FORMAT([Date],"ddd")

Gold Meals Served Average = [Gold Meals Served] / DISTINCTCOUNT('Date'[Date])

!Max_Min Color = VAR GetAllDays = ALLSELECTED('Date'[Weekday]) VAR GetMaxValue= MAXX(GetAllDays, CALCULATE([Gold Meals Served Average])) VAR GetMinValue= MINX(GetAllDays, CALCULATE([Gold Meals Served Average])) RETURN IF( [Gold Meals Served Average] = GetMaxValue,"#000e2f", IF([Gold Meals Served Average] = GetMinValue, "#ffda30","#b3b3b3") )

But getting not expected result:

Any idea of what could be the problem?

Thanks

Re: Highlighting the min & max values in a Power BI column chart

Anonymous — Thu, 27 Jul 2023 06:15:16 GMT

Hi carlosgeovany,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Re: Highlighting the min & max values in a Power BI column chart

ERD — Thu, 27 Jul 2023 07:04:44 GMT

Hi carlosgeovany ,

Your approach should work, but you need to check several things:

No need to put CALCULATE here:

VAR GetMaxValue= MAXX(GetAllDays, [Gold Meals Served Average])

Check that GetMaxValue and GetMinValue return the values you expect
Make sure your measure returns the value of the Text format

Re: Highlighting the min & max values in a Power BI column chart

carlosgeovany — Wed, 02 Aug 2023 20:57:13 GMT

Hi, I made some progres but still no the desired output.

Problem is when I sort the column Weekday by the column WeekdayNum so I can see the days in order

As you can see above, now the colors are as spected, but when I try to sort it, the colors change to the same