cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Analyze in excel insert timeline error

I have a date table with a date column with data type = 'date' formatted as date in my power bi model. When I export the dataset with Analzye in Excel I cannot insert a timeline slicer. I get the error message "We can't create a Timeline for this report because it doesn't have a field formatted as Date" Anyone know how to make this work? 

 

Thanks. 

6 REPLIES 6
Highlighted
Community Champion
Community Champion

Re: Analyze in excel insert timeline error

@bpratt I can't replicate this issue. Maybe what you need to do is on top of having column type as date also format it as date so maybe as dd/MMM/yy which you can do under Modelling tab.

 

Capture.JPG

Highlighted
Microsoft
Microsoft

Re: Analyze in excel insert timeline error

Hi @bpratt,

What is your data source? Based on my test, when I use SSAS database as data source, after exporting the dataset with Analyze in Excel, I am able to insert a timeline slicer as shown in the following screenshots.
1.PNG2.PNG


However, when I use other types of data source, I can reproduce your error message. It seems that Excel cannot recognize the Date column properly.
3.PNG


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: Analyze in excel insert timeline error

Hi @v-yuezhe-msft,

I was wondering if there have been any updates on this issue?  I'm encoutering the same issue and was hoping it would have been resolved by now.  Any help would be apprecaited.

 

Thanks.

Highlighted
New Member

Re: Analyze in excel insert timeline error

Hi @v-yuezhe-msft,

I'm just wondering if there have been any updates or fixes for this issue.  I've encountered the same issue when my original data source is a simply Excel file.  Our organization would like to use the advantages of PowerBI yet still have the final results (analysis) in Excel.  Any updates would be greatly appreciated.

Thanks.

Highlighted
Frequent Visitor

Re: Analyze in excel insert timeline error

I also await a fix for this issue.

Highlighted
New Member

Re: Analyze in excel insert timeline error

Hello,

There are 2 options :

- Column/Attribut with Data Type = Date
- Time Dimension : Mark as Date Table

More information : http://www.concatskills.com/2018/02/04/we-cant-create-timeline-because-report-doesnt-have-field-form...

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors