Birds On Wire

Here, we will show how to configure the “Birds On Wire” report included in the Sample Reports 

In the Power BI sample report, click on the Birds On Wire tab.

Birds On Wire report in the PowerGraph Gantt Timeline sample report

Here are the fields in the order they appear

Parent Category (required)

Parent Category defines the rows in the Timeline visual.  Multiple fields can be used to display a hierarchy. Our example shows: Project Name & Parent Task
From the Excel data file on the Birds-on-a-wire table, we will use Project Name.

Sample data used for the Parent Category field

Here is the field in the Parent Category field well:

Parent Category field well in the Power BI visualizations pane

In the visual the result is:

Gantt Timeline visual showing the result of the Parent Category field

Timeline Category (required)

Timeline Category is used to categorize both the Timeline Bars and Milestones and enables the ability to set Timeline Bar color by category, and Milestone color and shape by category.  From our sample data we will use the Timeline Category field.

Sample data used for the Timeline Category field

Here is the field in the Milestone/Task field well:

Milestone/Task field well in the Power BI visualizations pane

Timeline Bar (required)

This field supplies the name for each Timeline bar.  In many cases this will be the field used for the lowest level of the Parent Category – as in this case, we will use Timeline Bar 2.  Note that the visual will only use the data from the Project Name field when the Milestone/Task field is False:

Sample data used for the Timeline Bar field

Here is the field in the Timeline Bar field well:

Timeline Bar field well in the Power BI visualizations pane

Timeline Bar Text (optional)

The Timeline Bar Text field enables the display of text in the Timeline Bar.  In the example we will not use a Timeline Bar Text, so we leave that field well blank:

Timeline Bar Text field well in the Power BI visualizations pane

Timeline Bar Start Date, Timeline Bar Finish Date (optional)

The Timeline Bar Start and Finish dates are used by the Timeline visual to define the Timeline bar display.
From the sample data we will use Parent Task Start Date and Earliest Parent Task Finish Date:

Sample data used for the Timeline Bar Start Date, Timeline Bar Finish Date fields

Here is the field in the Timeline Bar Start and Finish Date field wells:

Timeline Bar Start Date, Timeline Bar Finish Date field wells in the Power BI visualizations pane

Baseline Bar Start and Finish Dates (optional)

If you have baseline date, these can be used to show baseline bars. In the example we will not use a Baseline Bar Start and Finish Dates, so we leave that field well blank:

Baseline Bar Start and Finish Dates field wells in the Power BI visualizations pane

Milestone

Much like the Timeline Bar field, Milestone is used to name the milestones.  Again, in many cases the field in the lowest Parent Category position will be used – as in this case, we use Milestone. Note that the visual will only use the data from the Task field when the Milestone/Task field is True:

Sample data used for the Milestone field

Here is the field in the Milestone field wells:

Milestone field well in the Power BI visualizations pane

Milestone Date

Milestones only need one date, and this is where it’s needed. In this example, we will use a Earliest Milestone date field well:

Sample data used for the Milestone Date field

Data Label

Data labels can be displayed on milestones, timeline bars or both.  For this example, we only want to display labels on milestones.  Our data has a field called Milestone which has data for milestones but not for timeline bars (this could also be accomplished through simple DAX):

Sample data used for the Data Label field

Sort By

Sort By allows for custom sorting of your data.  In the example we will not use a custom sort, so we leave that field well blank:

Sort By field well in the Power BI visualizations pane

% Completion

Percent completion will display a progress bar inside a timeline bar.  From our sample data we will use the Task Percent Completed field:

Sample data used for the % Completion field

Here is the field in the % Completion field well:

% Completion field well in the Power BI visualizations pane

Timeline Bar and Milestone Tooltips

The Tooltips field wells allow you to add one or more fields to be displayed for either Timeline Bars or Milestones.  For this example, we will leave them blank:

Timeline Bar and Milestone Tooltips field wells in the Power BI visualizations pane