Display Duration

What is Duration?

The Task Duration is the difference between the Start and End Dates. The Duration indicates the time frame that is available for the task to be completed. The Duration Type of a task identifies the relationship between the number of resources assigned to a task, the total effort, and the total Duration of the task.

Typically, we would need to write a DAX measure to determine the difference between dates. However, in the xViz Gantt chart, there is no need to write a DAX measure. The visual calculates the duration for you.

Duration in the xViz Gantt Chart

The xViz Gantt chart makes it easy to calculate duration using Actual dates and Planned dates, with the ability to show the duration in various units like days, weeks, months, etc. This visual provides flexibility and simplifies analysis by automatically adding additional columns to the chart showcasing the Duration, so you don't need to write any DAX measures.

Steps to Use Duration in Gantt Chart:

1. Add Dates to the Gantt Chart

Begin by inputting your actual dates into the Gantt chart

Image 1: Populating the Actual Start and Actual End Dates

2. Optional - Display Duration based on Planned Dates

To calculate the duration based on planned dates, add your planned start and end dates to the chart.

Image 2: Populating the Planned Start and Planned End Dates

3. Display Calculated Durations

Go to the Format Pane and select the option for Display Categories

Image 3: Display Categories section in the Format pane

4. Select Duration Type

In the Display Categories, you will find the Duration Type option where you can choose between

• Actual Dates

• Planned Dates

• Or Both

Image 4: Duration Type option in the xViz Gantt Chart

5. Choose Duration Units

You can display the duration in different units such as

• Months

• Weeks

• Days

• Hours

• Minutes

• Seconds

Image 5: Duration Unit option for the Duration column

6. Decimal places for Duration

There is an option to show durations with decimal places for more precise measurements.

Image 6: Decimal places option for the Duration column

7. Additional Formatting options

You can add suffixes to the duration values, change the title, and increase the width size of the column added.

Image 7: Formatting options for the Duration column

New column for Duration added

When you select the duration option, a new column will be added to the chart showing the calculated duration values.

• Actual Duration

  

  Image 8: Actual Duration column in the xViz Gantt Chart
• Planned Duration

  

  Image 9: Planned Duration column in the xViz Gantt Chart
• Both Actual and Planned

  

  Image 10: Both Actual Duration and Planned Duration columns in the xViz Gantt Chart

Note: To show Planned Duration at the Parent levels as well, ensure to enable the below option: Format pane -> Chart Options -> Show Planned Tasks