locked
Timeline not working RRS feed

  • Question

  • In my pivot table I cannot use the timeline and get this error below

    "string cannot be converted to the date type"

    The powerpivot posting date has a date type of "DATE" what more can I do fix this problem?

    Thanks in advance Kate

     

               
    Thursday, June 19, 2014 5:57 PM

Answers

  • Are you using a separate date table that is related to your fact table?

    Is that date table "Marked as Date Table" in the Power Pivot window?

    This is necessary for the timeline to function properly.

    • Proposed as answer by Michael Amadi Sunday, June 22, 2014 10:16 PM
    • Marked as answer by Elvis Long Monday, June 30, 2014 2:06 AM
    Thursday, June 19, 2014 8:42 PM
    Answerer