Documentation

Date Hierarchy

Since Drill Down Timeline PRO uses matrix data structure, this required field must contain column(s) that will be used to build a date hierarchy.



You can choose between using the default Power BI hierarchy, or creating your own date hierarchy that will allow you to use custom date/time units or specific time intervals as units (e.g., 15-minute intervals or 10 days; you can find all permitted column names on this page).


Standard Date Hierarchy

Power BI can automatically create a date hierarchy from a date/time value column. Drag the hierarchy from Data pane into the Data Hierarchy field, and you can select the drill down levels (year, quarter, month, day) for your time-based data.

date_hierarchy_1

Custom Date Hierarchy

If you want to use a non-standard date hierarchy and customize which time units or periods are used as hierarchy levels (for example, specific time intervals or units like milliseconds), you can create a custom date/time hierarchy by dragging your desired time units into the Date Hierarchy field. 


Important: The visual will only recognize date/time unit columns that are named in English and using accepted unit names. You can find a full list of all permitted column names on this page.

date_hierarchy_2

Individual date hierarchy components are simple numbers and have no date meaning of their own. The full date column is what allows Power BI to associate these values with date/time in your data model.