Forum Discussion
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 err...
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