Getting Started – Gantt

Welcome! This comprehensive guide will help you quickly get started with the Leaplytics Gantt Chart visual for Power BI, featuring interactive timeline visualization, task dependency management, categorical data mapping, enterprise project integration, and professional project presentation capabilities.

Jump to sections:
Overview | Data Setup | Basic Configuration | Advanced Features | Troubleshooting

📊 Comprehensive Feature Overview

🎯 Core Timeline Visualization ✨

Interactive Gantt Charts: Professional timeline visualization with task bars, milestones, and dependencies
Categorical Data Mapping: Optimized PowerBI integration with cross-filtering support
Timeline Navigation: Zoom, pan, and fit-to-view controls for large project datasets
Responsive Design: Automatically adapts to container size changes
Enterprise Scale: Supports 1000+ tasks with linear performance scaling

📈 Task Dependency Management ✨

Dependency Arrows: Visual relationship lines connecting related tasks
Multiple Dependency Types: Finish-to-Start, Start-to-Start, Finish-to-Finish, Start-to-Finish
Critical Path Analysis: Automatic identification of project critical path
Lag Time Support: Configurable delays between dependent tasks
Interactive Dependencies: Click and hover interactions for dependency exploration

🏗️ Project Data Integration ✨

Multi-Platform Support: Microsoft Project, Primavera P6, Jira, Azure DevOps, Asana
Flexible Field Mapping: TaskID, TaskName, StartDate, EndDate, Dependencies, Progress
Hierarchical Projects: Parent-child task relationships with configurable rollup
Real-time Updates: Live data refresh from PowerBI datasets
Cross-filtering: Bidirectional selection with other PowerBI visuals

🎨 Professional Visualization ✨

PowerBI Theme Integration: Respects report themes and color palettes
Configurable Styling: Custom colors, fonts, and visual formatting
Progress Indicators: Visual progress bars within task timeline bars
Milestone Markers: Diamond-shaped milestone indicators on timeline
Status-based Coloring: Automatic task coloring based on status or progress

🔄 Interactive Features ✨

Selection Management: PowerBI-compliant selection and highlighting
Tooltip Integration: Rich tooltips with task details and metadata
Context Menus: Right-click support for PowerBI standard actions
Keyboard Navigation: Accessibility-compliant keyboard interactions
Touch Support: Mobile-friendly touch interactions for timeline navigation

🏢 Enterprise Ready ✨

Performance Optimized: Efficient rendering for large project datasets
Security Compliant: No data transmission outside PowerBI environment
License Management: Enterprise licensing system with validation
Audit Trail: Complete change tracking and user interaction logging
AppSource Certified: Meets Microsoft PowerBI marketplace standards

📊 Enhanced Data Setup & Requirements {#data-setup}

⚠️ Important: Your data should follow a tabular structure with each row representing a task and columns containing task properties.

Enhanced Data Model Structure

-- Essential Gantt chart data structure ✨
SELECT 
    TaskID,                    -- Unique identifier for each task
    TaskName,                  -- Display name for the task
    StartDate,                 -- Task start date (required)
    EndDate,                   -- Task end date (optional if Duration provided)
    Duration,                  -- Task duration in days (optional if EndDate provided)
    Progress,                  -- Completion percentage (0-100)
    Status,                    -- Task status (Not Started, In Progress, Complete)
    ParentTask,                -- Parent task ID for hierarchical projects
    Dependencies,              -- Comma-separated list of predecessor task IDs
    DependencyType,            -- FS, SS, FF, SF (Finish-to-Start default)
    LagTime,                   -- Lag time in days for dependencies
    ResourceAssigned,          -- Assigned resources or team members
    Priority,                  -- Task priority (High, Medium, Low)
    Milestone                  -- Boolean indicator for milestone tasks
FROM ProjectTasks

Supported Data Sources Reference

Data Source	Platform	Status	Key Fields	Integration Notes
Microsoft Project	MS Project	✅ Primary	Task ID, Name, Start, Finish, Dependencies	Export as Excel or connect via Project Online
Primavera P6	Oracle	✅ Primary	Activity ID, Name, Start, Finish, Predecessors	Export as Excel or XML import
Azure DevOps	Microsoft	✅ Primary	Work Item ID, Title, Start Date, Target Date	Direct API connection or export
Jira	Atlassian	✅ Primary	Issue Key, Summary, Due Date, Links	Export or API integration
Excel/CSV	General	✅ Primary	Custom fields mapped to Gantt requirements	Direct PowerBI import
Asana	Asana	✅ Secondary	Task ID, Name, Start Date, Due Date	Export as CSV
Custom Tables	Database	✅ Secondary	User-defined schema matching Gantt model	Direct database connection

⚙️ Comprehensive Configuration Guide {#basic-config}

Step 1: Prepare Your Project Data

Data Validation: Ensure TaskID is unique and dates are valid
Dependency Format: Use comma-separated TaskIDs (e.g., "TASK001,TASK002")
Date Consistency: Verify all dates use consistent format (preferably ISO)
Hierarchy Structure: Validate parent-child relationships are logical
Progress Values: Ensure progress is numeric between 0-100

// Example data preparation validation
TaskData = {
    TaskID: "PROJ001-TASK001",
    TaskName: "Requirements Gathering",
    StartDate: "2025-01-15",
    EndDate: "2025-01-25", 
    Progress: 75,
    Status: "In Progress",
    Dependencies: "PROJ001-TASK000",
    DependencyType: "FS",
    LagTime: 2
}

Step 2: Configure Basic Gantt Visual

Add Visual: Insert the Leaplytics Gantt Chart visual into your PowerBI report
Map Required Fields:
- Task ID → TaskID column
- Task Name → TaskName column
- Start Date → StartDate column
- End Date → EndDate column (or Duration)
Test Basic Timeline: Verify tasks display as horizontal bars on timeline
Check Date Range: Ensure timeline spans appropriate project duration

Step 3: Enable Advanced Features ✨

🔗 Task Dependencies Configuration

Dependencies Field: Map Dependencies column to Dependencies field well
Dependency Type: Map DependencyType column (optional – defaults to Finish-to-Start)
Lag Time: Map LagTime column for dependency delays
Verify Arrows: Check that dependency arrows appear between related tasks

📊 Progress and Status Setup

Progress Mapping: Map Progress column to show completion within task bars
Status Configuration: Map Status column for automatic task coloring
Progress Display: Enable progress bars within timeline bars
Status Colors: Configure color scheme for different task statuses

🏗️ Hierarchical Project Structure

Parent Task Mapping: Map ParentTask column for hierarchical display
Expand/Collapse: Enable hierarchical navigation controls
Rollup Behavior: Configure how child task progress rolls up to parents
Indentation: Set visual indentation for task hierarchy levels

💎 Milestone Configuration

Milestone Field: Map Milestone boolean column
Milestone Style: Configure diamond-shaped milestone markers
Milestone Colors: Set distinct colors for milestone vs regular tasks
Date Alignment: Ensure milestones align correctly on timeline dates

🔍 Zoom and Pan Controls

Zoom Levels: Configure available zoom levels (days, weeks, months, quarters)
Pan Behavior: Enable smooth timeline panning with mouse/touch
Fit Controls: Add fit-to-view and fit-to-data buttons
Date Range: Set initial visible date range for timeline

🎨 Visual Styling and Themes

PowerBI Theme: Enable automatic PowerBI theme integration
Custom Colors: Configure task colors based on status, priority, or resources
Timeline Styling: Customize axis labels, grid lines, and background
Task Bar Styling: Set task bar height, borders, and text positioning

✅ Configuration Complete: You should now have a fully functional Gantt chart with interactive timeline, task dependencies, and professional project visualization.

🎯 Advanced Features Usage Guide {#advanced-features}

🔗 Advanced Dependency Management ✨

Dependency Types and Relationships

Finish-to-Start (FS): Predecessor must finish before successor starts (most common)
Start-to-Start (SS): Both tasks start simultaneously
Finish-to-Finish (FF): Both tasks finish simultaneously
Start-to-Finish (SF): Successor cannot finish until predecessor starts

Critical Path Analysis

Automatic Calculation: Visual automatically identifies critical path
Critical Highlighting: Critical path tasks highlighted with distinct styling
Path Navigation: Click critical tasks to highlight entire critical path
Schedule Impact: Visual indication of how delays affect project completion

Lag Time and Lead Time

Positive Lag: Delay between predecessor and successor (e.g., drying time)
Negative Lag (Lead): Overlap between tasks (parallel work)
Visual Indicators: Lag time shown as extended dependency arrows
Dynamic Updates: Lag calculations update automatically with schedule changes

📊 Interactive Timeline Features ✨

Zoom Controls: Mouse wheel, pinch-to-zoom, zoom buttons
Pan Navigation: Click-and-drag timeline movement
Date Navigation: Jump to specific dates or milestones
Fit Options: Fit-to-view, fit-to-data, fit-to-selection

Selection and Cross-filtering

Task Selection: Click tasks to select and highlight dependencies
Multi-select: Ctrl+click for multiple task selection
PowerBI Integration: Selected tasks filter other visuals in report
Highlighting: Related tasks automatically highlighted during selection

Timeline Scale Management

Adaptive Scaling: Timeline automatically adjusts to data range
Custom Ranges: Set specific start/end dates for timeline view
Scale Optimization: Optimal time unit selection (hours, days, weeks, months)
Business Calendar: Support for business days and holiday exclusions

🎨 Advanced Styling and Customization ✨

Task Bar Customization

Conditional Formatting: Color tasks based on status, priority, or custom fields
Progress Visualization: Multiple progress display options within task bars
Task Labels: Configurable task name positioning and formatting
Bar Styling: Custom borders, shadows, and visual effects

Milestone and Event Markers

Milestone Types: Different shapes for different milestone categories
Event Markers: Special indicators for key project events
Date Lines: Vertical lines for important dates (today, deadlines, reviews)
Annotations: Text annotations for key timeline points

Resource and Assignment Display

Resource Indicators: Show assigned resources on task bars
Resource Colors: Color-code tasks by assigned team or resource type
Workload Visualization: Visual indication of resource over-allocation
Team Grouping: Group tasks by team or department assignment

🏢 Enterprise Integration Features ✨

Multi-Project Management

Portfolio View: Display multiple projects in single timeline
Project Grouping: Hierarchical organization of project portfolios
Cross-Project Dependencies: Dependencies between different projects
Resource Sharing: Shared resources across multiple projects

PowerBI Dashboard Integration

Filter Integration: Responds to PowerBI slicers and filters
Bookmark Support: Save and restore specific timeline views
Export Capabilities: Export timeline as image or data
Drill-through: Navigate to detailed task or project reports

Performance Optimization

Data Virtualization: Efficient handling of large datasets (1000+ tasks)
Lazy Loading: Load task details on demand for better performance
Caching: Intelligent caching of calculated dependency paths
Incremental Updates: Efficient updates when underlying data changes

🔧 Comprehensive Troubleshooting Guide {#troubleshooting}

❌ Timeline Display Issues ✨

Tasks not appearing on timeline:

✅ Verify TaskID field is mapped correctly and contains unique values
✅ Check date fields contain valid dates in correct format
✅ Ensure date range covers the period where tasks should appear
✅ Verify data types are correctly recognized by PowerBI (dates as dates)
✅ Check for null values in required fields (TaskID, TaskName, dates)

Timeline scale problems:

✅ Check timeline zoom level – tasks may be outside visible range
✅ Use "Fit to Data" option to automatically adjust timeline scale
✅ Verify start/end dates have reasonable values (not extreme dates)
✅ Check for data filter issues that might hide tasks

❌ Dependency Arrow Issues ✨

Dependencies not showing:

✅ Verify Dependencies field is mapped to column with predecessor TaskIDs
✅ Check dependency format uses comma-separated TaskIDs (no spaces)
✅ Ensure referenced TaskIDs exist in the dataset
✅ Verify dependency arrows are enabled in format panel
✅ Check if tasks are within visible timeline range

Incorrect dependency relationships:

✅ Validate DependencyType field contains valid values (FS, SS, FF, SF)
✅ Check lag time values are numeric and reasonable
✅ Verify circular dependencies don't exist in the data
✅ Test with simplified dataset to isolate dependency issues

❌ Performance Issues ✨

Slow rendering with large datasets:

✅ Enable data virtualization in performance settings
✅ Limit visible date range to reduce rendered tasks
✅ Check for inefficient DAX calculations in data model
✅ Consider data aggregation for high-level timeline views
✅ Monitor PowerBI performance analyzer for bottlenecks

Memory usage concerns:

✅ Limit task count to recommended maximum (1000+ tasks)
✅ Enable automatic memory cleanup in visual settings
✅ Check for memory leaks in complex dependency calculations
✅ Use incremental refresh for large historical datasets

❌ Cross-filtering Problems ✨

Selection not working with other visuals:

✅ Verify categorical data mapping is correctly configured
✅ Check PowerBI cross-filtering settings for the visual
✅ Ensure TaskID field is used consistently across all visuals
✅ Test selection functionality with simplified report

Highlighting not responding:

✅ Check highlight data structure in categorical mapping
✅ Verify PowerBI selection manager integration
✅ Test with PowerBI table visual to confirm cross-filtering works
✅ Review selection ID generation for task data

❌ Data Mapping Problems ✨

Fields not recognized:

✅ Check field data types match expected formats (dates, numbers, text)
✅ Verify field mapping in Data pane matches column names
✅ Ensure calculated columns are properly defined in data model
✅ Test with simple dataset to isolate field mapping issues

Progress/status not displaying:

✅ Verify Progress field contains numeric values between 0-100
✅ Check Status field contains expected status values
✅ Ensure progress bars are enabled in format panel
✅ Test with sample data containing various progress values

❌ Hierarchical Structure Issues ✨

Parent-child relationships not working:

✅ Verify ParentTask field contains valid TaskIDs for parent tasks
✅ Check for circular parent-child references
✅ Ensure hierarchy levels don't exceed reasonable limits
✅ Test expand/collapse functionality with simple hierarchy

Rollup calculations incorrect:

✅ Check rollup configuration in format panel settings
✅ Verify child task data is complete and accurate
✅ Test rollup logic with known test cases
✅ Review date calculation logic for parent task spans

🎉 Advanced Best Practices

Data Preparation Excellence ✨

Data Quality: Validate all dates, ensure TaskIDs are unique, check dependency references
Performance Optimization: Limit dataset size, use appropriate data types, optimize DAX calculations
Hierarchy Design: Plan logical parent-child relationships, avoid deep nesting, maintain clear structure
Dependency Modeling: Map realistic dependencies, avoid circular references, use appropriate lag times
Testing Strategy: Test with sample data, validate all features, performance test with large datasets

Visual Configuration Best Practices ✨

Timeline Scaling: Choose appropriate default zoom level, configure reasonable date ranges, enable adaptive scaling
Color Strategy: Use consistent color schemes, map colors to meaningful data attributes, ensure accessibility compliance
Layout Optimization: Configure appropriate task bar heights, optimize text positioning, balance information density
Interactive Design: Enable intuitive navigation, provide clear visual feedback, support both mouse and touch interaction

Enterprise Deployment ✨

Security Configuration: Ensure data privacy compliance, configure appropriate access controls, validate PowerBI security model
Performance Monitoring: Monitor visual performance metrics, optimize for large datasets, plan for scalability requirements
User Training: Provide comprehensive user guides, conduct training sessions, establish support procedures
Maintenance Planning: Plan regular data refreshes, monitor visual performance, update configurations as needed

PowerBI Integration Excellence ✨

Cross-filtering Design: Plan effective cross-filtering strategies, design complementary visuals, ensure consistent data relationships
Dashboard Layout: Position Gantt visual effectively, balance information density, optimize for different screen sizes
Report Performance: Optimize overall report performance, minimize data model complexity, use efficient DAX patterns
User Experience: Design intuitive navigation, provide clear visual hierarchy, ensure accessibility compliance

🚀 Ready to Get Started?

This comprehensive visual transforms complex project data into beautiful, interactive Gantt charts that maintain professional quality and support sophisticated project management workflows directly in PowerBI dashboards. Your stakeholders will finally see project timelines the way they should be displayed – clear, interactive, and professionally formatted.

Transform your project data into professional timeline visualizations that drive better project decisions.

Quick Navigation