Try creating a calculated field similar to the following and place it on the columns shelf:
datename('month', [Order Date]) + ' ' + datename('day', [Order Date])
Then, place year on the color shelf and the desired measure on the rows shelf.
Hope this helps!
Can you just come sit in the office next to me and show me how to do EVERYTHING? Thanks for your help yet again!
I have ran into another problem with this task. The date fixed you told me worked great.
Now, if both years don't have data for the same date, the line that represents the year with data for that date skips and has a dot. Is there anyway to make the line continuous? I realize the the dates in between will not have reference points as they do not have data, but if Tableau has some kind of an option to just map the straight line between the points that would be great.
I hope it is ok to re post to this thread. There are still gaps in the line chart, so I figure the title is appropriate.