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

[carlosgeovany]

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

[ERD]

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 

[carlosgeovany]

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

[Anonymous]

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