Forum Discussion

Userpath77's avatar
Userpath77
Helper II
5 years ago
Solved

Conditional Formatting (2 Rules for same column)

Hello All I have these two DAX measures. I basically need to color one column two different colors (Red if date in other column is within 45 days and Yellow if within 60 days. I will need the 45 d...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hi Userpath77 ,

    I believe SWITCH would help here.

    MEASURE = 
SWITCH(
    TRUE(),
    SELECTEDVALUE('Table'[ColumnWithDate])-TODAY()<45,
    "RED",
    SELECTEDVALUE('Table'[ColumnWithDate])-TODAY()<60,
    "YELLOW",
    "WHITE"
)

     

Payeras_BI's avatar
Payeras_BI
Solution Sage
5 years ago

Hi Userpath77 ,

I believe SWITCH would help here.

MEASURE = 
SWITCH(
    TRUE(),
    SELECTEDVALUE('Table'[ColumnWithDate])-TODAY()<45,
    "RED",
    SELECTEDVALUE('Table'[ColumnWithDate])-TODAY()<60,
    "YELLOW",
    "WHITE"
)

 

  • Userpath77's avatar
    Userpath77
    Helper II
    5 years ago

    Thanks Payeras-----I had to adjust it a little, but worked perfect! Thanks again.