Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

PowerPivot Timeline Error with DateTable

I have a data model built into my excel spreadsheet with multiple tables that use a date field. Inside of PowerPivot, I used the create calendar feature, and then I linked all of my tables to the new calendar. When I create a pivot, the date parameters work fine. But when I try to make a timeline slicer, I get the error "Microsoft Excel can't create a timeline because it can't get the required date field information."

What gives?

Status: New
Comments
v-chuncz-msft
Community Support

@Anonymous 

 

You may check data type and visit https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat for dedicated support.