Forum Discussion

aivoryuk's avatar
aivoryuk
New Member
10 years ago

Timeline Slicer

Is there a limitation to how many, months and Days etc that the timeline can show? I'm connecting from a MD cube and it won't show all the years -   when I do narrow down the years and select a dat...
Tips and Tricks
greggyb's avatar
greggyb
Resident Rockstar
10 years ago

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.

 

Plechazunga's avatar
Plechazunga
Regular Visitor
10 years ago

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