Forum Discussion

bpratt's avatar
bpratt
Frequent Visitor
9 years ago

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. 

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Follow below steps to

    Go to Power BI DataModel.

    Select the Date Table

    Right Click as select 'Mark as Date Table'

    Save and Publish the dataset to Power BI Service.

    In Power BI Service, select 'Analyze in Excel'  option

    You should be now able to use timeline slicer

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    9 years ago

    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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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.



    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.



    Thanks,
    Lydia Zhang

    • rbhandal's avatar
      rbhandal
      New Member
      9 years ago

      Hi Anonymous,

      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.

    • rbhandal's avatar
      rbhandal
      New Member
      9 years ago

      Hi Anonymous,

      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.