Wednesday, December 31, 2014

Excel Timeline Error: We can’t create a Timeline for this report because it doesn't have a field formatted as Date.

You might get the error below when trying to insert a Timeline filter in an Excel Pivot table that is built off of an SSAS (SQL Server Analysis Services) Cube. Timeline filter is a new feature of Excel 2013 that can be used as a ‘visual filter’ to filter data in pivot tables.

We can’t create a Timeline for this report because it doesn't have a field formatted as Date.


It appears that the Timeline filter requires the MemberValue property of the key column in the date dimension to be a date field (date or datetime both works). So to resolve this issue, just point the ValueColumn property of the key column of your date dimension to a date field as shown in the screen shot below.


Also, please note that Timeline filter also requires the Type property of the date dimension to be set to Time. Hope this is helpful.

5 comments:

  1. Can u keep posting the next steps that make the way to the Timeline

    ReplyDelete
  2. the date key properties are not available.

    ReplyDelete
  3. From where you open this window

    ReplyDelete
    Replies
    1. Select the key column of your date dimension, and then go to properties (or you can select key column of your date dimension and hit F4).

      Delete
  4. How to open this window :( what is the key column?

    ReplyDelete