Conditional Formatting based on X-axis Value using DAX

[Chirag4370]

Hello Experts, @MFelix

I need help to highlight column of Latest Month.

means change column color based on X-axis Values dynamically.

highlite column with selected color where date/month in X-axis is latest/max. below SS is desired result.

I have written below DAX and applied to column color but it changes all bar color with latest.

LatestMonthColumnColor =
VAR maxMonth = CALCULATE( max(CycleDayUnpivot[EndDate1stOfMonth]), ALL(CycleDayUnpivot))
RETURN IF(MAX(CycleDays[EndDate1stOfMonth])=maxMonth, "#EE9771")

[Chirag4370]

Thank You @bhanu_gautam @bchager6 @fahadqadir3

got it.

[Anonymous]

@Chirag4370 Did you add your measure to the conditional formatting of the column color in the format pane?

[fahadqadir3]

@Chirag4370  Review the following attached screenshot and DAX formula:

LatestMonth = 
CALCULATE(
MAX('financials'[Date]),
ALL('financials')
)

IsLatestMonth = 
VAR LatestMonth = MONTH([LatestMonth])
VAR LatestYear = YEAR([LatestMonth])
VAR CurrentMonth = MONTH(MAX('financials'[Date]))
VAR CurrentYear = YEAR(MAX('financials'[Date]))
RETURN 
IF(CurrentMonth = LatestMonth && CurrentYear = LatestYear, 1, 0)

@Chirag4370  Hope it works.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!! 

[bhanu_gautam · Accepted solution]

@Chirag4370 , Create one measure for Latest Month

LatestMonth = CALCULATE(MAX(CycleDayUnpivot[EndDate1stOfMonth]), ALL(CycleDayUnpivot))

And trying updating second measure

LatestMonthColumnColor =
VAR maxMonth = [LatestMonth]
RETURN IF(MAX(CycleDays[EndDate1stOfMonth]) = maxMonth, "#EE9771", "#DefaultColor")