Forum Discussion

mateusz_ta's avatar
mateusz_ta
Frequent Visitor
11 months ago
Solved

Conditional formatting not working

I have a matrix visual with dates as values. If the date is not older than 6 months then the value should be green. However, for example, the first field of the matrix says 2025-08, hence, the backgr...
Need Help
Show and Tell
Tips and Tricks
  • Aburar_123's avatar
    Aburar_123
    11 months ago

    Hi mateusz_ta ,

    Please follow the below approach,

    write a measure like below,

    BG color = IF(MAX(FACT_Orders[Order Date])<=TODAY() && MAX(FACT_Orders[Order Date])>=EDATE(TODAY(),-6),"Green","Red")
     
    use this measure in the Background color formula,
     

    then the result will be as you expected as below

     

     

     

    Thanks.

Aburar_123's avatar
Aburar_123
Solution Supplier
11 months ago

Hi mateusz_ta ,

Please follow the below approach,

write a measure like below,

BG color = IF(MAX(FACT_Orders[Order Date])<=TODAY() && MAX(FACT_Orders[Order Date])>=EDATE(TODAY(),-6),"Green","Red")
 
use this measure in the Background color formula,
 

then the result will be as you expected as below

 

 

 

Thanks.