Timeline Start/End

xViz Gantt Chart offers flexibility to use Default, Static or Dynamic dates in the Timeline.

  1. Default - The timeline range is defined by the earliest start date and the latest end date from the data provided in the date fields. When any filter is applied, this range adjusts dynamically based on the filtered date values.

  2. Static - Define static dates for the timeline start and end. Irrespective of any filtering or dates of the tasks or today's date, the timeline range will remain static.

  3. Dynamic - Provide DAX measures to determine the timeline start and end dates. The best use case is for Rolling timelines where the context of today's date is essential. For example: If it starts today (Nov 7, 2024) and shows the next 2 years, in one month, it will be dynamically adjusted to show from Dec 7, 2024, to Dec 7, 2026, keeping the 2-year view as time moves on.

Step to Configure Static Dates
  1. Open the Advanced Editor Icon

    Image 1: Advanced Editor option

  2. Open the Timeline section.

    Image 2: Timeline Tab in Advanced Editor

  3. Options of Start Date and End Date will be shown:

    Image 3: Start Date and End Date options to define the Range

  4. Select the drop drown option for Start Date/End Date and select the "Static Date" option:

    Image 4: "Static Date" option for Start Date and End Date to define the static Range

  5. Select the Date from the Calendar:

    Image 5: Static Dates set for both Start Date and End Date

  6. Click on the Save button to save the changes:

    Image 6: Start Date and End Date applied to Timeline Range

Benefit! This enables to keep the Timeline static despite applying filters/slicers.

Steps to add Dynamic Dates

The Rolling timeline in a Gantt chart dynamically shifts the displayed time range.

Example: If it starts today (Nov 7, 2024) and shows the next 2 years, in one month, it will be dynamically adjusted to show from Dec 7, 2024, to Dec 7, 2026, keeping the 2-year view as time moves on.

Let's see the steps to set it up:

  1. Create the DAX measures for Dynamic Start Date and Dynamic End Date ad below:

Rolling Timeline Start = TODAY()
Rolling Timeline End = EDATE(TODAY(), 24)

Note: DAX Measures for Dynamic Start Date and Dynamic End Date may vary based on different use cases and business requirements

  1. Populate the 'Timeline Start/End' Date field with the above DAX measures.

    Image 7: Populate Timeline Start/End field
  1. In the Timeline section, select 'Data' for Start Date/End Date and choose the respective measures as shown image below:

    Image 8: Choose respective measures in Timeline tab
Combination of Dates
  1. In the Timeline section we can use a combination of dates.

  2. Can show the Start date as a Static date and End date as Data.

    Image 9: Start and End Dates can have different types of values to define the Timeline Range

Last updated

Was this helpful?