Do you want to create a Gantt chart in a Power BI report? No worries!
In this Power BI tutorial, I will tell you what a Power BI Gantt chart is and how to add and create a Gantt chart in Power BI report step by step.
Power BI Gantt Chart
- In Power BI, Gantt charts are like colorful bar graphs where each bar represents a task, and the length of the bar shows how long the task takes.
- This way, we can easily understand the schedule and keep track of progress at a glance.
- A Gantt chart with a horizontal line axis represents the total time required to complete a task.
How to Create a Gantt Chart in Power BI
I will explain how to create a Gantt chart in a Power BI in simple steps.
I have a SharePoint list named Employee Leave list having the below columns [with different data types]:
| Columns | Data Types |
|---|---|
| EmployeeID | Number |
| EmployeeName | Single line of text |
| LeaveType | Single line of text |
| StartDate | Date and time |
| EndDate | Date and time |
| Duration | Number |
| Status | Single line of text |
1. Open Power BI Desktop and load data using the Get data option.
Unfortunately, the Gantt Chart is not a built-in chart. You can’t see the Gantt chart under the Visualization panel. We will add a Gantt chart to the Power BI Visualization panel. To do this, follow the below steps.
2. Under the Visualizations panel, click the three-dot(…) -> click Get more visuals.
3. Sign in with your office account (school or work account) to Power BI. If you don’t have one, don’t worry. Here is how to create your account.
Next, enter your Email account and click Continue.
4. Then, a Power BI visuals window opens. In the search bar, search Gantt -> Select the first with the verified (checkmark).
5. Click on the Add button.
6. Now, we can see this Gantt chart under our visualization Panel.
7. Click on the Gantt chart under the visualization panel. Then, drag ‘EmployeeName’ into ‘Parent,’ ‘LeaveType’ into ‘Task,’ ‘StartDate’ into ‘Start Date,’ and ‘EndDate’ into ‘End Date’ fields.
8. Now, I will create two slicers. Click on the slicer and drag “LeaveType” into the slicer field. Repeat the process: click on the slicer and drag “EmployeeName” into the slicer field.
This way, you can create a Gantt chart in the Power BI report.
Conclusion
I hope you found this article helpful for the Gantt Chart in Power BI report.
In this article, we covered what a Gantt chart is, how to add a Gantt chart in Power BI, and the steps to create a Gantt chart in a Power BI report.
Also, you may like some more Power BI tutorials:
- Select Multiple Values in Power BI Slicer
- How to Sync Slicers in Power BI
- Create Power BI Pie Chart On Map
- Sort a Power BI Table by Multiple Columns
Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.
