ECS Milestone Trend for Power BI

Track how milestone completion dates change across reporting periods with professional trend visualization.

Key Features

Trend Analysis

• Visualize milestone forecast evolution over time
• Compare current forecasts against baseline dates
• Automatic variance calculation and color coding
• Identify slipping or improving milestones at a glance

Data Integration

Works seamlessly with project data from:

• Primavera P6 (Oracle)
• Microsoft Project
• Asta Powerproject
• Excel/CSV exports
• ECS Platform (recommended for automated data extraction)

Professional Visualization

• Multiple marker shapes (Circle, Square, Diamond, Triangle)
• Flexible trend lines (smooth curves, linear, or step)
• Comprehensive formatting controls
• 8 legend position options
• Data labels with dates and variance
• Grid lines and customizable axes

Business Value

• Identify schedule trends early
• Improve forecast accuracy
• Track milestone stability over time
• Professional presentation quality
• Reduce manual trend analysis time

Data Requirements

Required Fields:

• Milestone names or identifiers (Category)
• Data Date labels - reporting period names (Category)
• Forecast Date - milestone completion dates (Measure)

Optional Fields:

• Data Date - actual reporting dates for timeline spacing (Category)
• Baseline Date - original planned dates for variance (Measure)

Recommended Data Source

The ECS Platform (https://www.ecs.app) automatically extracts and structures schedule data, including milestones, activities, resource assignment and timephasing, from Oracle Primavera P6, Microsoft Project, and Asta Powerproject, providing optimal formatting for this visual.

About ECS

Engineering and construction systems pty Ltd (ECS) provides project controls solutions for mining, oil & gas, energy, infrastructure, and construction industries.

Not affiliated with Oracle Corporation. "Primavera" and "P6" are trademarks of Oracle Corporation.
Not affiliated with Microsoft Corporation. "Power BI" and "Microsoft Project" are trademarks of Microsoft Corporation.
Not affiliated with Elecosoft plc. "Asta Powerproject" is a trademark of Elecosoft plc.