Forum Discussion
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...
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.
Hi mateusz_ta,
You may want to try changing the Format style option to Rules instead of Field value. Then you can explicitly define the conditions for when the background should be green or red (e.g., if the date is within the last 6 months → green, otherwise → red).
This approach ensures the formatting logic is applied directly in the visual, rather than relying on the last field value returned by your measure, which can sometimes lead to unexpected results in a matrix.
I don't see a conditional formatting rule option that could be applied directly to a column with a date format.