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.

v-hashadapu's avatar
v-hashadapu
Community Support
11 months ago

Hi mateusz_ta , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.