Others

How to Fix One-Day Durations in a Power BI Gantt Chart

Steve KSteve K Nov 11, 2026 868 views

Question details

Users are experiencing an issue in Power BI Gantt charts where every task is incorrectly displayed with a single one-day duration.

How to Fix One-Day Durations in a Power BI Gantt Chart
Product
Power BI
Device & OS
not provided
Scenario
Creating a Gantt chart timeline using custom or built-in visuals in Power BI.
Observed behavior
Every task on the Gantt chart timeline appears as a one-day duration, and changing the aggregation settings (such as setting it to Count) fails to generate the correct project timeline.
Before you start

Before troubleshooting, ensure that your data source correctly formats the Start Date and End Date columns as Date/Time data types, and check the specific name of the custom Gantt visual you have imported.

Solution 1Recommended

Verify Field Configuration and Data Types

The most common cause for one-day durations is assigning the wrong aggregation to duration fields or incorrect date formatting.

Gantt charts rely heavily on precise data typing. If a date is recognized as plain text, or if a duration uses a 'Count' aggregation instead of a numeric value, the visual will default to a single day for each task.

1
Select the visual

Click on your Gantt chart visual on the Power BI canvas and open the 'Visualizations' pane on the right side.

2
Check date columns

Examine the 'Start Date' and 'End Date' field wells. Switch to the Data view to confirm their data type is strictly set to 'Date' or 'Date/Time'.

3
Fix the aggregation setting

Click the dropdown arrow next to the duration or end-date field in the Visualizations pane. Ensure it is not set to 'Count'. Change it to 'Don't summarize' or 'Sum' if you are using a numeric duration column.

Verify Field Configuration and Data Types
Avoid Count Aggregation: Using 'Count' as a substitute for a duration value simply counts the number of rows for that task, which usually results in a value of 1. This forces the visual to plot a one-day duration.
Free Microsoft Office alternative

Manage Data and Create Project Charts with WPS Office

While Power BI handles complex business intelligence dashboards, managing project timelines and Gantt charts can often be done more easily in spreadsheets. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office, perfect for organizing project data, tracking durations, and visualizing timelines without a steep learning curve.

  1. 1. Download the software: Visit the official WPS Office website and download the free installation package.
  2. 2. Install and launch: Follow the on-screen prompts to install the suite, then open WPS Spreadsheet.
  3. 3. Import and visualize data: Open your existing project management files with complete format retention and easily insert bar charts to map out your timeline.
Fully compatible with Microsoft Excel (.xlsx) formats and chartsBuilt-in chart templates to easily visualize project timelines and durationsFree and lightweight suite for PC, Mac, and mobile devicesFamiliar user interface for seamless migration from MS Office
QA img-9

Frequently Asked Questions

Why does my Power BI Gantt chart show all tasks starting on the exact same date?

This usually occurs when the Start Date column contains blank values, is accidentally formatted as text instead of a Date data type, or the relationship with your calendar/date table is broken in the data model.

Can I create a Gantt chart in Power BI without downloading custom visuals?

Power BI does not have a native Gantt chart in its default visualization pane. You must either import one from Microsoft AppSource or use a stacked bar chart as a creative workaround.

How do I calculate task duration in Power BI if my data only has start and end dates?

You can calculate this by creating a custom column in Power Query using the formula `Duration.Days([End Date] - [Start Date])`, or by using DAX to create a calculated column with `DATEDIFF('Table'[Start Date], 'Table'[End Date], DAY)`.