Please see attachments, again, my end result is the following. I want to show YTD, Full Accumulation, with months < Today() formatted GREEN() if ACTUALS beat PLAN, is ACTUAL are under PLAN, RED(). IF Months are >= Today(), format them RGB(128, 128, 128).
Example Chart: Conditional Coloring Based on Date Range
I think you need an expression like the following. I am assuming that you have a fiscal date field in your data model..
You basically need to disregard all the other date releated selections like FiscalMonth,FiscalYear and just filter your data on your main date field(between Jan this year and year(Max(Your Date Field)) or Year(Today()).. Hope this helps