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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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.