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

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Reply
Giada90
Helper IV
Helper IV

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
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.