Forum Discussion

Chirag4370's avatar
Chirag4370
Helper I
2 years ago
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 ...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    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")

fahadqadir3's avatar
fahadqadir3
Solution Supplier
2 years ago

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!!