Forum Discussion
Timeline Slicer
I have a similar problem. I import Project Online Data with an OData stream. I need a timeline slicer for a date field called TimeByDay. The timeline slicer raises an error message, because the field is not a date field. I tried it several ways to format a date field, but the timeline slicer doesn't work. No I have to use Excel Power Pivot because a time slicer is a core requirement. This is extremely frustrating and disappointing, to say the least. Things like that do not happen when you work with Qlik!
Plechazunga, are you changing the Data Format or the Data Type? Data Format is a display option. You can use Data Format to cause a Date-Time of "2016-01-01 13:57:02" to be displayed as "2016-01-01", but the underlying data still includes the time portion.
You can also change the Data Type. Altering the Data Type affects the underlying data. Changing the Data Type of the Date-Time "2016-01-01 13:57:02" to Date will cause the underlying value stored in the data model to be "2016-01-01". Make sure you're changing Data Type not Data Format.
greggyb Thank you now I have it there is one precondition you need to apply when using time Timeline slicer: you have to switch off the date hierarchy, and this works with this little context menu. It is not the date format, here the Timeline slicer has a broad tolerance.
with date hierarchy no go
switch it off then it works