Create A Gantt Chart In Power BI Report Builder: An Introduction

Gantt charts are a go-to tool for project managers and teams to track timelines and progress in an easy-to-understand visual format. With Power BI Report Builder, you can take this visualization to the next level by incorporating interactive, data-driven elements. In this tutorial, we will cover the basics of creating a Gantt chart in Power BI Report Builder, including how to transform dates into numbers using calculated fields.

Add A Title & Subtitle In A Gantt Chart In Power BI Report Builder

Create a blank report page. The first item you need to add is the report title. For this example, use Project Tasks – GANTT Chart.

Once you’re done typing the title, you can change its size, position, and style in the Properties pane located on the right-hand side.

gantt chart in Power BI

Below the report title, you can add a dynamic subtitle that changes depending on the data shown in the report.

Write the beginning phrase and then drag and drop the field you want from the Report Data pane to the Subtitle.

Since the report is presenting a Gantt chart, the subtitle shows the chart range of the project start and end dates. You can change the chart range format using the Format option in the Properties pane.

When you run the report, this is how the title and subtitle will look like.

gantt chart in Power BI

The subtitle automatically changes depending on the parameters you set.

Create A Calculated Field To Transform Dates Into Numbers

To create a Gantt chart in Report Builder, you’ll be using a gauge chart. However, this type of chart doesn’t work with dates. So you need to create a calculated field that allows you to transform the dates into numbers.

To create a calculated field, click on your dataset and select Add calculated field.

This opens the Dataset Properties window. Before anything else, you need to sort out the formatting of the parameters.

Click Add Calculate Field and type in the Field Name. In this case, it’s StartDateFormat. Then, click the fx button.

In the Expression Builder, follow the format below:

gantt chart in Power BI

Then, copy this code and paste it in a new Calculated Field. For this example, the new calculated field is called EndDateFormat. In the Expression Builder, you only need to change the Field used in the expression.

gantt chart in Power BI

After you click OK, you need to make sure that the Parameters are using the calculated fields you created. So go to the Report pane, right-click on the ChartRangeStart and select Parameter Properties.

In the Report Parameter Properties wizard, go to the Available Values tab. Set the calculated field you created as the Label field.

gantt chart in Power BI

Do the same for the ChartRangeEnd Parameter.

When you run the report, the Project Start Date and Project End Date parameters appear in an easier to read format.

Start Number & End Number In A Gantt Chart In Power BI Report Builder

To change the date parameters from a date to a number format, you need to create new calculated fields. In this example, we will call them StartNumber and EndNumber.

In the Expression Builder, create a field that will count the number of days between the Chart Range Start and End values. The gauge will then present the difference.

gantt chart in Power BI

Do this for the Start and End fields. Don’t forget to change the Fields according to what’s needed. For the StartNumber, use the ChartRangeStart parameter and the Start_Date value.

On the other hand, use the ChartRangeEnd parameter and the End_Date value for the EndNumber.

***** Related Links *****
Creating A Gantt Chart In Power BI Using Matrix
Report Builder In Power BI: Formatting Objects & Visualizations
Deneb Power BI Declarative Visualization

Conclusion

A Gantt Chart makes it easier to track each task in a project. Adding this in your paginated report allows end users to be aware of ongoing and pending tasks.

The great thing about using Report Builder is how easy it is to make a dynamic report. Though it doesn’t have the option to automatically create a Gantt chart, you can work your way around and use a Gauge chart instead.

All the best,

Sue Bayes

Enterprise DNA Power BI On-Demand

The Latest

If you’ve been working with Python for data analysis or machine learning, you’ve likely come across NumPy arrays. They’re a powerful tool for handling numerical data, but sometimes, the data…

How to normalize a numpy array a quick guide.

Multiplying lists in Python is a common operation when performing mathematical computations or solving problems in data manipulation. There are multiple ways to achieve this task, depending on your requirements…

How to Multiply Lists in Python: A Simplified Guide

If you’ve been wrestling with Python lists and wondering how you can save them as a neat CSV file, you’re in the right place. One of the most common tasks…

How to Write a List to CSV in Python

Do you need to write an essay on the fall of the roman empire with accurate citations but have no time to find them? Are you tired of painfully having…

What is Caktus AI: A comprehensive overview

Pandas is a widely used Python library for data manipulation and analysis. One essential functionality that pandas can provide you is the ability to modify the structure of a dataset….

Pandas Drop Index: Efficiently Remove DataFrame Rows or Columns

Working with strings is a common task in Python. You often need to figure out whether a string contains another string. The simplest methods to check if a Python string…

7 Ways to Check if a Python String Contains Another

Ever found yourself knee-deep in Python files, struggling to import a module from a parent directory? If so, you’re in good company. Python’s import system can sometimes feel like a…

Python Import from Parent Directory: A Quick Guide

Data is the backbone of businesses these days, and having proof that you know how to handle and make the most out of data is a big deal in the…

Microsoft DP-500

In programming, you may encounter situations where a variable does not have a value. These instances are commonly represented by a special value known as null. Many programming languages, such…

Null Python: 7 Use Cases With Code Examples

Truncating a floating-point number in Python is a common operation that many programmers encounter in various applications. The process involves removing the decimal place of a float, leaving only the…

Python Truncate Flow: A Streamlined Approach for Efficient Code Execution

OpenAI’s ChatGPT tool has taken the world by storm and has been at the forefront of revolutionizing the way we generate content, do research, and even create code. And just…

Is ChatGPT worth it, let's work it out.

As you continue your journey as a Python programmer, you’ll want to write code that is more efficient, readable, and easy to maintain. The Python programming language comes with a…

Python Inline If: Simplify Your Conditional Expressions

Load More