Forum Discussion
Solved
Conditional Formatting based on X-axis Value using DAX
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 ...
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")
Chirag4370 Did you add your measure to the conditional formatting of the column color in the format pane?