Conditional formatting on the X-axis

hi Anonymous ,

Not sure if i fully get you. Supposing you have a data table like:

Try to

1) create a calculated dates table like below and connect with data[date]. 

dates = 
ADDCOLUMNS(
    CALENDAR(MIN(data[date]), MAX(data[date])),
    "YYMM", FORMAT([Date], "yy/mm")
)

2) create another calculated slicer table like below and keep it unrelated:

slicer = dates

3) plot a slicer with slicer[date] column;

4) plot a column chart with dates[yymm] and data[amt] column, and apply conditional formatting for the column color with a measure like:

Color = 
VAR _minsliceddate = MIN(slicer[date])
VAR _maxsliceddate = MAX(slicer[date])
VAR _minslicedmonth = YEAR(_minsliceddate)*12+MONTH(_minsliceddate)
VAR _maxslicedmonth = YEAR(_maxsliceddate)*12+MONTH(_maxsliceddate)
VAR _currentdate = MAX(dates[date])
VAR _currentmonth = YEAR(_currentdate)*12+MONTH(_currentdate)
VAR _result =
SWITCH(
    TRUE(),
    _currentmonth =_minslicedmonth, "Orange",
    _currentmonth=_maxslicedmonth, "Blue",
   _currentmonth=_maxslicedmonth-1, "Black",
    "Gray"
)
RETURN _result

it worked like: