Merge columns in column chart

[jonbox]

Hi,

I'm trying to show the result of a new column i created as one column within a barchart:

Spend + Prediction = 
VAR _monthtoday =
    MONTH ( TODAY () )

VAR _month_table =
    MONTH ('Actual Spend + Firm'[Date] )
RETURN
    IF (
        _month_table >= _monthtoday
            ,
        'Actual Spend + Firm'[Pred_Adj],
        'Actual Spend + Firm'[ActualSpending_Loc]
    )

 The above code essentially creates a column by usinga certain value from either Pred_Adj or ActualSpending_Loc based on if the month is in the past or future. e.g. use Actualspending_Loc up until may, then use Pred_Adj.

In a table the data shows correct but in a column chart it splits the column into two bars:

Is there any way to merge the two blue  columns into one? is this something i need to do in the DAX formula or the graph itself?

[lbendlin · Accepted solution]

show the x axis field details  of your chart.