Highlight Max month with different color

[Anonymous]

Hi, 

I'd like to show the max month for a clustered column chart to highlighte by defalault the max month only with a different color using conditional formatting. 

 I'm using the below DAX, yet it's not working;

User Trend Value:= var __HighValue = MAXX(ALLSELECTED(DateTable[Month Year]), [UniqueUsage%]) return IF([UniqueUsage%]=__HighValue, "#2AD2C9", "#4472C4")

DateTable[Month Year] looks like this:

[amitchandak]

@Anonymous , You need max month of month with max value . That for month with max value

User Trend Value:= var __HighValue = MAXX(allselected(DateTable), DateTable[Month Year])
return IF(max(DateTable[Month Year])=__HighValue, "#2AD2C9", "#4472C4")

[Anonymous]

@amitchandak the color logic worked perfectly, yet it's highlighting Sep 2020. Not sure why is that!

[amitchandak]

@Anonymous , If the first one worked. The values making sure you take max at the month level, not below it.

If the second one worked. we are taking the max of the selected months and using it.

[Anonymous]

@amitchandak  I tried to use VALUES, however it's highlighting all bars in one sinle color neglecting the max month that is Dec 2020

[amitchandak]

@Anonymous , Try like

User Trend Value:= var __HighValue = MAXX(values(DateTable[Month Year]), [UniqueUsage%]) return IF([UniqueUsage%]=__HighValue, "#2AD2C9", "#4472C4")

I am assuming you are able to use conditional data color formatting with "field value" option

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak  I tried to use VALUES, however it's highlighting all bars in one sinle color neglecting the max month that is Dec 2020