Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Giada90
Helper III
Helper III

particular chart

Hi,

I need to do something like this:

excel-diagrammi-gantt-1.png

 

and I have something like this for database:

 

activityduration in days
phase 110
phase 220
phase 330
phase 440

 

how can I do?

which free power bi graph can I use?

thanks

1 ACCEPTED SOLUTION
v-menakakota
Community Support
Community Support

Hi @Giada90 ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.


Yes, you can get this by Gantt chart by MAQ software as suggested by @pankajnamekar25 ,thank you pankajnamekar for providing possible solutio.
Here is the detailed process how to achieve it:

Take a sample dataset which has the following column names Activity (Phase Name),Start Date, Duration (in days),End Date (optional). From get more visuals search for Gantt chart by MAQ software and add it. Select the Gantt chart and add the fields in the Gantt chart by Task name,Start date,End date and duration. If your dataset only has Start date and Duration,you can calculate End Date using this DAX:

End Date = 'Table'[Start Date] + 'Table'[Duration (Days)]

Here is the screen shot for better understanding:

vmenakakota_0-1742967888963.png

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

 

View solution in original post

2 REPLIES 2
v-menakakota
Community Support
Community Support

Hi @Giada90 ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.


Yes, you can get this by Gantt chart by MAQ software as suggested by @pankajnamekar25 ,thank you pankajnamekar for providing possible solutio.
Here is the detailed process how to achieve it:

Take a sample dataset which has the following column names Activity (Phase Name),Start Date, Duration (in days),End Date (optional). From get more visuals search for Gantt chart by MAQ software and add it. Select the Gantt chart and add the fields in the Gantt chart by Task name,Start date,End date and duration. If your dataset only has Start date and Duration,you can calculate End Date using this DAX:

End Date = 'Table'[Start Date] + 'Table'[Duration (Days)]

Here is the screen shot for better understanding:

vmenakakota_0-1742967888963.png

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

 

pankajnamekar25
Super User
Super User

Hello Giada,

 

You can create Gantt chart to achive this.

please explore the article in details .

You should have date column in your dataset and Milestone to show 

bing.com/ck/a?!&&p=a7dcf3ef39d1227c4fd977bc1b3bfae959cee994b366a8bcaa7dd44ea06a3cd2JmltdHM9MTc0Mjg2M...

 

Thanks,
Pankaj

If this solution helps, please accept it and give a kudos, it would be greatly appreciated.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.