How to Fix One-Day Durations in a Power BI Gantt Chart
Question details
Users are experiencing an issue in Power BI Gantt charts where every task is incorrectly displayed with a single one-day duration.

- 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 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.
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.
Click on your Gantt chart visual on the Power BI canvas and open the 'Visualizations' pane on the right side.
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'.
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.

Seek Support in the Power BI Community
Since most Gantt visuals in Power BI are custom add-ins from AppSource, specific visual bugs may require specialized community support.
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. Download the software: Visit the official WPS Office website and download the free installation package.
- 2. Install and launch: Follow the on-screen prompts to install the suite, then open WPS Spreadsheet.
- 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.

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)`.




