You might get the error below when trying to insert a
Timeline filter in an Excel Pivot table that is built off of an SSAS (SQL
Server Analysis Services) Cube. Timeline filter is a new feature of Excel 2013
that can be used as a ‘visual filter’ to filter data in pivot tables.
We can’t create a Timeline for this report because it doesn't
have a field formatted as Date.
It appears that the Timeline filter requires the MemberValue
property of the key column in the date dimension to be a date field (date or
datetime both works). So to resolve this issue, just point the ValueColumn
property of the key column of your date dimension to a date field as shown in
the screen shot below.
Also, please note that Timeline filter also requires the
Type property of the date dimension to be set to Time. Hope this is helpful.
Can u keep posting the next steps that make the way to the Timeline
ReplyDeletethe date key properties are not available.
ReplyDeleteFrom where you open this window
ReplyDeleteSelect the key column of your date dimension, and then go to properties (or you can select key column of your date dimension and hit F4).
DeleteHow to open this window :( what is the key column?
ReplyDeleteDon't forget option "Mark As Date Table" on Time Dimension : http://www.concatskills.com/2018/02/04/we-cant-create-timeline-because-report-doesnt-have-field-formatted-as-date/
ReplyDelete"Great read! Learn java full stack developer course
ReplyDeletewith practical exercises to build robust applications and advance your career."
Android developer classes provide structured learning paths. They focus on app design and logic. Practice sessions improve coding ability. Guidance ensures clarity. This android developer classes supports success. It is reliable.
ReplyDeleteA python programming program builds strong coding foundations. It focuses on problem-solving techniques. This python programming improves technical skills. It is effective.
ReplyDelete"Excellent insights! java full stack developer course
ReplyDeletefrom scratch with hands-on coding exercises and real-world projects in our online course. Start your coding journey today."