Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
hello, I want to make a gantt chart like the image below. I have data with columns date, type, project_id, status before, status after. in the image, requires end_date to be input into the visual. What are the steps so that I can create a visual like in the picture? Thank you.
example data:
| date | type | project_id | status_before | status_after |
| 1/10/2023 7:43:38 | Create project | b4ba5 | Working on it | |
| 1/10/2023 9:53:22 | Update project | b4ba5 | Working on it | On review |
| 1/16/2023 9:17:30 | Create project | b3baf | Working on it | |
| 1/17/2023 14:11:58 | Update project | b3baf | Working on it | On review |
| 1/24/2023 8:21:14 | Create project | 328ae | Waiting | |
| 1/24/2023 10:24:51 | Update project | b4ba5 | On review | Finished |
Hi @zheon7 ,
I created a sample pbix file(see the attachment), please check if that is what you want.
Best Regards
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 130 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |