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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

@PoorAndNeedy 

 

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