TFS 2010 Task Burndown Excel Report not showing any data?

This is a quick tip to those of you that are struggling to get any data to show up onto the Task Burndown excel report in the TFS agile 5.0 dashboard.

For some reasons unknown to me, the date filter on the "Date" row label is filtering all dates, even though it is configured to filter "This Month."




I was able to select the dates I wanted without the filter and show the report however that was still a little frustrating.

To fix this instead of using "Date" dimension for the row label is used a "Date Set > Last 4 Weeks" which has a similar effect to "This Month"