Free 30-Days trial for xViz visuals here!

Multi-level Timeline in the xViz Gantt Chart for Power BI

Prachi Mishra
September 28, 2023

Timelines are the most important component in a Gannt Chart because they show you the essential chronological context for tasks and projects; They tell you when tasks start and how long they will take.

The ability to adjust and customize these timelines while interacting with the Gantt Chart gives users a valuable opportunity to scrutinize and assess the project plan in alignment with their specific preferences and requirements.

TimelineGeneric
Figure 1: Timeline in the xViz Gantt Chart for Power BI

Our xViz Gannt Chart gives you a robust suite of tools and configurations to visualize your timelines within Power BI:

1. Multi-level timeline

2. Zoom levels configuration

3. Zooming capabilities

4. Zoom Range Setting

Multi-level Timeline:

The xViz Gantt Chart offers the capability to incorporate up to three distinct levels within the timeline, thereby enhancing the provision of additional date and time context while maintaining a clutter-free timeline view.

Different end users often have different viewing perspectives and would like to look at the timeline on different date/time units. For instance, a development manager would be interested in looking at the timeline in terms of weeks. While the construction contractor would be interested in tracking the timeline at the day level.

Timeline-Levels
Figure 2: Multi-level timeline in the xViz Gantt Chart for Power BI

In the above example, the timeline is shown in three levels – Year, Quarter, Month. With multiple levels, the view provides multiple contexts but with a clean view.

Each zoom level can be easily toggled on/off in the visual format pane settings:

Timeline-Levels-Settings
Figure 3: Timeline level settings in the xViz Gantt Chart

Additionally, the visual provides a range of formatting options to tailor the appearance and style of each timeline level:

Timeline-Levels-Formatting
Figure 4 : Timeline level formatting options in the xViz Gantt Chart

Zoom Levels Configuration:

It is important to define the levels of the timeline. In addition, providing users with the ability to switch to deeper levels gives great flexibility. The same view can cater to a broader audience when different time unit perspectives can be provided.

Configure the zoom levels by specifying the date/time unit to be displayed at each level, utilizing the Zoom Levels settings accessible through the Advanced Editor. Additionally, you can define skip numbers for the respective units to fine-tune the level of detail.

Zoom-Levels
Figure 5: Quarter->Month->Day Levels Configuration in the xViz Gantt Chart

In the above example, the three levels are configured as Quarter -> Month -> Day. Notably, the skip numbers are set to Quarter = 1, Month =1, and Day = 10. This configuration results in the display of every quarter and every month, while only every 10th day is presented on the timeline.

Similarly, we can have different configurations as per the requirement:

Year-Qtr-Month
Figure 6: Year-> Quarter-> Month Levels Configuration
Month-Week-Day
Figure 7: Month-> Week -> Day Levels Configuration

xViz Gantt Chart provides 8 options of Timeline units to configure for the timeline levels:

Timeline-Units
Figure 8: Timeline Units in the xViz Gantt Chart

Zooming Capabilities:

Enable report consumers with the capability to zoom into the timeline effortlessly, either by utilizing the mouse wheel or the visual's built-in zoom navigation controls. Zooming functions to stretch the timeline, providing a finer-grained perspective of the data.

Zoom-Options
Figure 9: Enable zoom for end-users

Continuing to zoom in triggers an automatic adjustment of the timeline levels in accordance with the predefined settings outlined in the Zoom Levels configuration.

Zoom Levels
Figure 10: Zooming through multiple zoom levels in the xViz Gantt Chart

In the provided example, the initial configuration sets the levels to Year -> Quarter -> Month. Upon further zooming in, the levels transition to Month -> Day -> Hour, and with even more granularity, they progress to Day -> Hour -> Minute, accommodating the user's need for varying levels of temporal detail.

Zoom Range Setting:

Configure the zoom range setting to specify the span of the timeline that should be visible at any given moment.

Zoom-Range
Figure 11: Zoom Range settings in the xViz Gantt Chart

In the provided example, the timeline is set to display a 5-year period. If the timeline encompasses more years beyond this range, a horizontal scroll feature is introduced, allowing users to navigate to the remaining timeline data.

The default position of the scroll is determined by the “Zoom Anchor” option.

In conclusion, the remarkable flexibility offered by the xViz Gantt Chart's timeline configuration simplifies the process of visualizing tasks and projects across various timeline units. The inclusion of zooming options enhances interactivity, giving report consumers the freedom to seamlessly visualize the timeline at varying levels of granularity. This combination of adaptability and user-friendliness empowers users to gain deeper insights and make more informed decisions when working with projects and tasks in Power BI.

Try the xViz Gantt Chart (Microsoft certified) for Power BI from Microsoft AppSource here.

xViz
About xViz!
xViz is a leading provider of advanced enterprise-grade visuals for Microsoft Power BI. The powerful, intuitive, and customizable data visualization experience of xViz, maximizes the potential of the data and elevates analysis to new heights. This product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as Inforiver, xViz and ValQ.
PBI Certified

Headquarters

5920 Windhaven Pkwy
Plano TX 75093

cross linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram