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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

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

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

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

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.