How are you getting the targets joined to the actuals data? The targets need to be the left side of a left join, the right side of a right join, or in a full outer join to be shown.
You won't be able to use blending for this because it will limit down to only the month values in both data sources.
I suggest making sure your join is a full outer join and that you are selecting the month from the Targets data source, not from the Actuals data source. Hope that helps!
Joining Main Data to Targets using a join calc:
STR(DATEPART('year',[DATE]))+"/"STR(DATEPART('month',[Date])))+"/"+ = STR(DATEPART('year',[DATE1]))+"/"STR(DATEPART('month',[Date1])))+"/"+
It was only a left join to the [DATE] from the main data source. The targets ([Date1] are obviously from a static Excel file. Those are joined in the same exact way as above.
So now everything is in a full outer join.
I've selected "Show missing values", "Show Empty Columns"...
I also took you advice and selected the month from the Target Dates source file. It shows all months now (even though its filtered for 2018)... but no data. Almost there... but dear lord this is frustrating.... ugh.
It's tricky to say without seeing the data. I would try right clicking the data source and "view data" so you can see if the Actuals are coming through correctly in the join. If they are, I would check the filters and then make sure no other data sources are blending in.
Looks like you're getting closer!