Documentation - Process Gantt
Overview
The Process Gantt visual offers a clear, graphical representation of a project’s progress.
This visual provides an overview of all scheduled tasks, allowing stakeholders to easily understand which tasks need to be completed and by what deadlines. The Gantt chart outlines the start and end dates for each project or activity, presenting a comprehensive timeline.
By analyzing existing processes through the Gantt chart, companies can assess the current state of their operations and identify opportunities for improvement.
Moreover, the Gantt chart can display log data to monitor ongoing processes, such as production or high-frequency data load operations. It tracks the time and duration of each task, enabling the quick identification of potential bottlenecks in the workflow.
For process or process flow charting, the required data should be in the form of an event log or project schedule, which includes the following key components:
- Category/Event/Activity: The specific task or event within the process.
- Parent Category/Project ID: The overarching category or identifier for the project to which the task belongs.
- Timestamps (Start/End): The start and end times for each task or event, providing a clear timeline for the process flow.
The visualization also interacts seamlessly with other visuals, allowing it to filter and affect the display of other elements. Users can customize the Process Gantt visualization through various settings available in the Power BI formatting pane, offering flexibility and control over its appearance and behavior.
- Format bars (color/edge/…)
- Format text (font/color/size/…)
- Format axis
- Format title
- …
Dropzones
- Category
- 1 x Attribute
- Defines which categories the data will be divided into.
- Parent-Category
- 1 x Attribute
- Divides the categories into parent categories.
- Start Time
- 1 x Attribute
- Contains the time information when the event/action starts.
- End Time
- 1 x Attribute
- Contains the time information when the event/action ends.
- Tooltips
- n x Attributes/Metrics
- The content of the Attributes/Metrics is displayed in the tooltip of the visualization.
- Attributes that are use in one of the other dropzones as well are not displayed in the tooltips.
Formatting settings
Gantt settings
Title
Show Title:
Option to show or hide the title of the visual.
The following options are available:
- ON
- The title is displayed.
- OFF
- The title will not be displayed.
Text:
Assignment of an additional title that is also displayed in the visualization.
Enter the title in the text field, this will be accepted unformatted.
Font:
Set the fonts for the title.
There is a large selection of different fonts, provided by Power BI.
Font size:
Set the font size for the title.
A range of font sizes is available to suit different layout needs and preferences, with selectable values from 6 pt to 60 pt.
Font weight:
Setting the font weight for the title, choice between:
- Normal
- Bold
Text color:
Set the font color using Power BI’s built-in color selector.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency setting lets you control how transparent the title appears. A value of 0 means the title is fully opaque (non-transparent), while 100 makes it completely transparent.
Category
Label
In the options menu Category > Label settings for the formatting of the category are made:
Alignment:
This settings allows you to place the label on the left or the right side.
Font:
Setting of the font of the category.
There is a large selection of different fonts, provided by Power BI.
Font size:
Set the font size for the category.
A range of font sizes is available to suit different layout needs and preferences, with selectable values from 6 pt to 60 pt.
Font weight:
Setting the font weight for the category:
- Normal
- Bold
Text color:
Set the font color using Power BI’s built-in color selector.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency setting lets you control how transparent the text appears. A value of 0 means the text is fully opaque (non-transparent), while 100 makes it completely transparent.
Past bar
In the options menu Category > Past bar, the formatting of the bar for past events can be changed.
When is this formatting used?
This formatting is used for all bars with both start time and end time in the past.
Name:
Choose a name for your Past bar, this one is displayed in the legend.
Fill color:
Setting the fill color for the Past bar.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Line width:
Set the border width for the Past bar.
- OFF
- There is no border width.
- ON
- There are different size options for the border width you can choose of. Starting from 0.1px to 8.0px.
Line color:
Setting the border color for the Past bar.
This setting will be disabled when the line width is set to “OFF“.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency setting lets you control how transparent the border line appears. A value of 0 means the Line is fully opaque (non-transparent), while 100 makes it completely transparent.
Round corners
Choose between round or square corners of the bar of the categories.
Active bar
In the options menu Category > Active bar, the formatting of the bar for current events can be changed.
When is this formatting used?
This formatting is used for all bars with a start time in the past and an end time in the future.
Name:
This name is displayed in the Legend, if activated.
Fill color:
Setting the fill color for the Active bar.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Line width:
Set the border width for the Active bar.
- OFF
- There is no border width.
- ON
- There are different size options for the border width you can choose of. Starting from 0.5px to 8.0px.
Line color:
Setting the border color for the Active bar.
This setting will be disabled when the line width is set to “OFF“.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Future bar
In the options menu Category > Future bar, the formatting of the bar for future events can be changed.
When is this formatting used?
This formatting is used for all bars with both start time and end time in the future.
Name:
This name is displayed in the Legend, if activated.
Fill color:
Setting the fill color for the Future Activity Format.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Line width:
Set the Line width for the Future bar.
- OFF
- There is no stroke width.
- ON
- There are different size options for the Line width you can choose of. Starting from 0.5px to 8.0px.
Line color:
Setting the Line color for the Future bar.
This setting will be disabled when the line width is set to “OFF“.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Error bar
In the options menu Category > Error bar, the formatting of erroneous events can be changed.
When is this formatting used?
This formatting is used for all events that cannot be displayed correctly due to an incorrect data set. For example:
- If the end time is before the start time.
- If the start time is missing or has a incorrect format.
Name:
This name is displayed in the Legend, if activated.
Fill color:
Setting the fill color for the Error Bar.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Line width:
Set the stroke width for the Error Bar.
- OFF
- There is no stroke width.
- ON
- There are different size options for the Line width you can choose of. Starting from 0.5px to 8.0px.
Line color:
Setting the stroke color for the Error Bar.
This setting will be disabled when the line width is set to “OFF“.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Duration value
In the options menu Category > Duration value, settings for the duration value of a bar are made.
Show Duration:
The toggle on the right side lets you enable/disable the duration value.
Position:
Lets you configure the position of the text relative to the bar. You can choose from the following:
- Inside right
- Outside right
- Inside left
- Outside left
- Center
Show unit:
The toggle on the right side lets you enable/disable the duration value unit.
Unit:
Here, the user can choose the unit used to display the duration value in.
They can choose from the following:
- auto
- ms
- sec
- min
- h
- day
- week
- month
- year
Decimal places:
Specifies the number of decimal places to display for duration values.
You can choose a value from 0 to 5.
Font:
Setting of the font of the duration value of the category.
There is a large selection of different fonts, provided by Power BI.
Font size:
Set the font size for the duration value of the category.
A range of font sizes is available to suit different layout needs and preferences, with selectable values from 6 pt to 60 pt.
Font weight:
Setting the font weight for the duration value of the category:
- Normal
- Bold
Text color:
Set the font color using Power BI’s built-in color selector.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency setting lets you control how transparent the duration value appears. A value of 0 means the duration value is fully opaque (non-transparent), while 100 makes it completely transparent.
Parent category
Show Parent category
This setting allows the user to choose, whether the parent categories should be displayed.
- ON
- The parent categories are displayed.
- OFF
- The parent categories are not displayed.
General
Toggle symbol:
Choose between different Toggle symbols for your parent category (and Bars):
- Arrow
- Plus/Minus
- Plus/Minus square
Collapse all:
This setting allows you to collapse the parent categories or to unfold them.
Label
Settings for the Labels of parent categories are set in options menu Parent category > Label.
Alignment:
Align the label of the parent category to the Left or Right.
Default name:
Assignment of an alternative parent category name that is displayed in the visualization in case no parent category is available.
Font:
Setting of the font of the parent category.
There is a large selection of different fonts, provided by Power BI.
Font size:
Set the font size for the parent category.
A range of font sizes is available to suit different layout needs and preferences, with selectable values from 6 pt to 60 pt.
Font weight:
Setting the font weight for the parent category:
- Normal
- Bold
Text color:
Set the font color using Power BI’s built-in color selector.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency setting lets you control how transparent the label appears. A value of 0 means the label is fully opaque (non-transparent), while 100 makes it completely transparent.
Bar
In the settings menu Parent category > Bar, settings for the Parent category bar are made.
Style:
Set the Style for the parent category. This can be a Line or a Bar.
Fill color:
Set the fill color for the Active bar.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Line width (Bar/Line):
Set the line width for the Bar/Line. This setting changes depending on the selected Style.
- OFF
- There is no Line width.
- Only available if the Style – Bar is selected.
- ON
- There are different size options for the Line width you can choose of. Starting from 0.5 px to 4.0 px.
Line color:
Setting the line color for the Active bar.
This setting will be disabled when the line width is set to “OFF“.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency setting lets you control how transparent the bar/line appears. A value of 0 means the it is fully opaque (non-transparent), while 100 makes it completely transparent.
Round corners:
Choose between round or square corners of the bar/line of the parent categories.
Duration value
In the option menu Parent category > Duration value, settings for the duration value of the parent categories are made.
Show Duration value:
Set whether the duration value should be displayed.
- ON
- The duration value is displayed.
- OFF
- The duration value is not displayed.
Position:
This setting lets the user decide, where they want the duration value to be positioned relative to the parent category.
They can choose from the following:
- Inside right
- Outside right
- Inside left
- Outside left
- Center
Show unit:
This setting lets the user decide, whether the duration value of the parent category should be displayed.
Unit:
Set the unit that is used to calculate/display the duration value.
They can choose from the following:
- auto
- ms
- sec
- min
- h
- day
- week
- month
- year
Decimal places:
Specifies the number of decimal places to display for duration values.
You can choose a value from 0 to 5.
Font:
Setting of the font of the duration value of the parent category.
There is a large selection of different fonts, provided by Power BI.
Font size:
Set the font size for the duration value of the parent category.
A range of font sizes is available to suit different layout needs and preferences, with selectable values from 6 pt to 60 pt.
Font weight:
Setting the font weight for the duration value of the parent category:
- Normal
- Bold
Text color:
Set the font color using Power BI’s built-in color selector.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency setting lets you control how transparent the duration value of the parent category appears. A value of 0 means the duration value of the parent category is fully opaque (non-transparent), while 100 makes it completely transparent.
Axis
Show Axis:
This setting lets the user choose, whether the visual should have an axis, what information that axis should include will be set under General.
General
General settings for the axis of the visual are made in the options menu Axis > General.
Axis postion:
The position of the Axis can be set “Bottom” or “Top”.
Axis type:
The Axis type can be “Absolute time” or “Relative time”.
Label
In the options menu Axis > Label, settings for the label of the axis can be changed.
Show line:
The toggle on the right allows you to hide or show the line of the axis.
Value format:
This setting sets the format of the displayed dates. You can choose from:
- PowerBI Format
- SCvation Format
- Total number
Time zone:
Set the time zone – UTC or Local
Font:
Setting of the font of the axis label.
There is a large selection of different fonts provided by Power BI.
Font size:
Set the font size for the axis label.
A range of font sizes is available to suit different layout needs and preferences, with selectable values from 6 pt to 60 pt.
Font weight:
Setting the font weight for the axis label:
- Normal
- Bold
Font color:
Setting the font color for the axis label.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency function lets you control how transparent the axis label appears. A value of 0 means the axis label is fully opaque (non-transparent), while 100 makes it completely transparent.
!Notice the following three options are only available when Total Numbers is chosen above in the Value Settings!
Value scaling (Total number):
Here you can set how you want the axis label to be scaled. This can be set to milliseconds, seconds, minutes, hours, days, weeks, months or years.
Show unit:
Enable/Disable the unit next to the axis label.
Decimal places (Total number):
Setting the number of decimal places of the axis label.
Line
In the options menu Axis > Label, settings for the line of the axis can be changed.
Line width:
Setting the width of the line from 0.5 px to 4.0 px.
Line color:
Setting the font color for the line.
This setting will be disabled when the line width is set to “OFF“.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency setting lets you control how transparent the line appears. A value of 0 means the line is fully opaque (non-transparent), while 100 makes it completely transparent.
Gridlines
Vertical
In the options menu Gridlines > Vertical, settings for the vertical gridlines can be made.
Show Gridlines:
The Button on the right allows you to hide or to show the gridlines.
Style
Choose between a Solid, Dashed or Dotted style for the gridlines.
Width:
Setting the width of the line from 0.5 px to 4.0 px.
Color:
Setting the font color for the gridlines.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency setting lets you control how transparent the gridlines appear. A value of 0 means the gridlines are fully opaque (non-transparent), while 100 makes it completely transparent.
Current timestamp
Show Current timestamp:
The toggle on the right allows you to enable/disable the current timestamp.
Line
Style:
Choose between a Solid, Dashed or Dotted style for the current timestamp line.
Width:
Setting the width of the line from 0.5 px to 4.0 px.
Color:
Setting the color for the current timestamp line.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency setting lets you control how transparent the line of the current timestamp appears. A value of 0 means the line is fully opaque (non-transparent), while 100 makes it completely transparent.
Label
Show Label:
The toggle on the right allows you to enable/disable the current timestamp label.
Alignment:
Choose between the options Left, Center and Right to position the current timestamp label.
Replacement text:
Choose which text is shown instead of the default value. The default value is the current Timestamp. The format of the current Timestamp depends on the format that is set for the Start Time data field.
Font:
Setting of the font of the current timestamp label.
There is a large selection of different fonts, provided by Power BI.
Font size:
Set the font size for the current timestamp label.
A range of font sizes is available to suit different layout needs and preferences, with selectable values from 6 pt to 60 pt.
Font weight:
Setting the font weight for the current timestamp label
- Normal
- Bold
Text color:
Set the font color using Power BI’s built-in color selector.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency setting lets you control how transparent the text appears. A value of 0 means the text is fully opaque (non-transparent), while 100 makes it completely transparent.
Label box
Show Label box:
The buttom on the right allows you to turn the Label box on or off
Background color:
Choose a background color for your Label box.
Line width:
Set the line width:
- OFF
- There is no Line.
- ON
- There are different size options for the Line width you can choose of. Starting from 0.5 px to 4.0 px.
Border color:
Setting the color for the current timestamp Label box.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency setting lets you control how transparent the label box appears. A value of 0 means it is fully opaque (non-transparent), while 100 makes it completely transparent.
Legend
In this setting, changes can be made regarding the Legend.
Show Legend:
The toggle on the right allows you to enable/disable the Legend.
General
Alignment:
Align the legend to the left, center or right.
Titel
Show titel:
The buttom on the right allows you to turn the titel text of the legend on or off.
Text:
Set the title for your legend.
Font:
Setting of the font of the legend title.
There is a large selection of different fonts, provided by Power BI.
Font size:
Set the font size for the legend title.
A range of font sizes is available to suit different layout needs and preferences, with selectable values from 6 pt to 60 pt.
Font weight:
Setting the font weight for the text:
- Normal
- Bold
Text color:
Set the font color using Power BI’s built-in color selector.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency setting lets you control how transparent the legends title appears. A value of 0 means it is fully opaque (non-transparent), while 100 makes it completely transparent.
Label
Font:
Setting of the font of the label.
There is a large selection of different fonts, provided by Power BI.
Font size:
Set the font size for the label.
A range of font sizes is available to suit different layout needs and preferences, with selectable values from 6 pt to 60 pt.
Font weight:
Setting the font weight for the label:
- Normal
- Bold
Text color:
Set the font color using Power BI’s built-in color selector.
Color selection options:
- Choose a color from the Power BI color theme using the color picker buttons.
- For more precise customization, enter a hex code directly into the text field within the color picker to define a specific color.
Transparency:
The transparency setting lets you control how transparent the label appears. A value of 0 means it is fully opaque (non-transparent), while 100 makes it completely transparent.
Tooltips
Show Tooltips:
The toggle on the right allows you to enable/disable the tooltips.
Advanced
Batch load
The Batch Load feature improves performance by rendering the visual in smaller batches rather than loading the entire dataset at once. This reduces the initial load time of both the visual and the report. As users scroll to the bottom of the visual or click a designated button, additional data is dynamically loaded and displayed.
Level:
Specifies the granularity at which data loading is limited:
- All: Loads the entire dataset.
- Parent category: Loads a specified number of parent categories.
- Category: Loads a specified number of categories.
Batch size:
Defines the number of parent categories or categories to load initially. As users scroll to the bottom of the visual, the next batch is automatically loaded based on this setting.
License
Information about the currently active license.
The visual includes an advanced licensing implementation, allowing it to work with both Microsoft AppSource plans, as well as custom license keys issued directly by SCvation GmbH. Additionally, the visual can be used free of charge, under the constraints of the free tier restrictions.
License type
Displays the type of the currently active license, as well as the progress when activating a new custom license.
The following license types are possible:
- Free
This license type is displayed if no license is available, i.e. no AppSource license has been assigned to your Microsoft/Power BI user and the visual has not been activated with a custom license key. All restrictions of the free tier apply for this license type. - AppSource License Plan
This license type is displayed if your Microsoft/Power BI user has an assigned AppSource license for the visual. After purchasing a plan on AppSource, the licenses need to be assigned in the Microsoft 365 Admin Center. Please note that because this license type is bound to the currently logged in user, it does not guarantee that all report viewers will have a valid license as well. Report viewers that do not have an AppSource license assigned will be subject to all restrictions of the free tier as well. - Licensee Custom License
This license type is displayed if a SCvation provided license key was used to activate the visual, and the license key has not yet expired. Licensee will usually be your company’s name. This license type guarantees that all report viewers can use the visual without restrictions, as the license is bound to the visual instance itself and not to specific users.
Additionally, you may encounter the following messages in this text field, when trying to activate the visual using a custom license key:
- Validating…
This message is displayed if the visual is currently validating the custom license key. If the validation succeeds, the correct license type (see above) will be shown again and the expiry date will be adjusted. Should there be a problem with the validation, one of the below error messages will be displayed instead. No internet access is required to validate a custom license key. - Expired
This error message is displayed if the stored custom license key expired. This can either happen when trying to validate an already expired key, or if a previously valid key has since expired. This error message is permanent and will only go away by validating a different custom license key. If a custom license key expires, the visual will still work, although under the restrictions of the free tier. - Invalid License Key
This error message is displayed if the given text is not a valid license key. After a few seconds the correct license type (see above) type will be shown again. - Invalid Product
This error message is displayed if the given text is a valid custom license key, but for the wrong SCvation product. After a few seconds the correct license type (see above) will be shown again.
License expiry date
If the visual is activated via a license key from SCvation GmbH, you will find the date on which the license expires here.
License key input
License keys purchased from SCvation GmbH can be imported here to activate the visual and remove the free tier restrictions.
Free tier restrictions
Licensed feature
When a valid license is detected, all features of the Process Gantt visualization are fully available without restrictions.
Without a license, settings marked as “Licensed Feature” (indicated by an asterisk * in the formatting pane) cannot be modified. Attempting to change these settings will trigger a notification and a watermark within the visual. These indicators are removed automatically when all licensed features are reset to their default values and the data limit has not been exceeded.
This setup enables you to explore and evaluate the full functionality of the Process Gantt visualization before purchasing a license.
Data limits
If a valid license is not detected, data rendering is limited. In this case, only the first 5 rows of the dataset are displayed in the visual.
When this data limit is reached, a notification and watermark will appear within the visualization to indicate the restriction. These indicators are automatically removed once the dataset falls below the limit, and all “Licensed features” revert to their default state.