I'm trying to match actual numbers compared to targets for specific time frames. However, the data source I get actual numbers for only has dates that have data (past dates only). If I want to match up targets to the whole year (including future quarters/months), it will only show up until the current month or current quarter where there are values. If I want to show future data, or % to goal for entire year, the charts don't populate because there are no future dates.

How can I revise the date field to at least have rows for the dates so I can pull in the data?

Tableau really works best at visualizing data. Creating data or extra data cannot be added in Tableau Desktop. The data would need to be added to the underlying data set via the data source editor(wheter it be excel or updating a data base table)

There is a way to show or hide empty columns from the data set in Tableau.