CP Gantt Chart

cpGantt Chart – custom visual for MS Power BI

cpGantt Chart is a web-ready Gantt chart visual for clear project and timeline management. It displays tasks along a time axis with start and end dates, durations, milestones, and grouping, helping teams track progress and spot bottlenecks at a glance. The visual supports customizable colors to highlight priorities and phases. Interactive features—such as zooming, panning, and rich tooltips—make it easy to explore complex schedules. Additionally, cpGanttChart can show supplementary measures for tasks in a dedicated area, enabling deeper context alongside the timeline. It adapts to different screen sizes and integrates smoothly into dashboards and analytics pages, providing a concise, intuitive view of your project roadmap.

Key Features

  • Flexible task hierarchies: supports both flat lists and parent–child structures (ParentID → ID → Task Name) aligned with Power BI data models.
  • Intuitive hierarchy navigation: drill to the desired task level using dedicated level controls for quick focus and context.
  • Dedicated measures area: display any task-related measures from your model (e.g., Cost, Effort, Status, Priority, Owner, etc.) in a separate panel.
  • Baselines and milestones: visualize baseline start/finish and milestone markers directly on the timeline for easy comparison and tracking.
  • Seamless zoom and scroll: adjust the timeline scale and pan effortlessly for smooth exploration of large schedules.

How to use

  1. Download the cpGantt Chart from the Power BI visual marketplace and add it to your report page.
  2. Add task name columns to the Tasks field. Tasks in the data model are typically organized either as a flat hierarchy or as a parent–child hierarchy. The flat hierarchy is selected by default. If you use a parent–child hierarchy, switch to Parent–Child in the Format pane. For ragged flat hierarchies, blank rows for empty levels may be hidden. To achieve this, the measures used by the cpGantt Chart visual must return blank() for empty levels (see the .pbix samples for examples).
  3. Add task start and finish date measures to the “Task start date” and “Task finish date” fields. Task lines should appear on the Chart area of the visual.
  4. Add a percent complete measure to the “% Complete” field. Task lines should reflect the percent complete, with a different color for the completed portion.
  5. Add baseline (planned) start and baseline finish date measures to the “Task baseline start” and “Task baseline finish” fields. A second line will appear for each task if both baseline start and baseline finish are not blank.
  6. Add a milestone measure to the “Milestone” field. The milestone measure must return either true, a number greater than 0, or any non-empty text to mark milestone tasks. Only detailed (non-summary) tasks can be displayed as milestones, regardless of the milestone measure value for summary tasks. Milestone tasks are shown as diamonds on the chart.
  7. Add any other measures you want to show in the middle area of the visual to the “Measures” field.
  8. Use Format panel to change the look and feel of the elements of the cpCantt Chart.

Note: The cpGantt Chart uses measures to determine task Start, Finish, BaselineStart, BaselineFinish, and other fields. If you choose to use table columns instead, please apply the appropriate aggregation (for example, MIN for the task Start date and MAX for the Finish date). Using measures also helps eliminate empty or duplicate rows in ragged task hierarchies. (See dowloaded samples below for details.)

Download .pbix samples

 

Licensing

Free License

The Free license provides full access to all core and advanced features of the visual, with only one limitation:

  • Up to 100 detailed tasks can be loaded and displayed in the visual.

This option is ideal for small projects, testing, personal use, training, or evaluating the visual before upgrading.
All visualization, interaction, formatting, and export features remain fully available.

Pro License

The Pro license unlocks the complete experience with no task limitations.

  • Unlimited number of detailed tasks
  • Full functionality without restrictions
  • Designed for production use, enterprise projects, and large datasets

The Pro license is available for 3 USD per month and ensures smooth work with large, complex schedules where task volume exceeds the Free tier limits.