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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Girish_123
Helper I
Helper I

How to create Gannt chart using default visuals.

Project NameStart Project Date End Project Date YearProject Duration

A

Friday, June 10, 2016Monday, September 30, 202488 Year 3 mos
BFriday, May 1, 2020Friday, June 30, 202333 Year 1 mos
CMonday, March 22, 2021Friday, March 31, 202322 Year 0 mos
DWednesday, January 6, 2016Friday, June 30, 202377 Year 5 mos
ESunday, February 1, 2015Friday, October 31, 20251010 Year 8 mos

 I want a output Like Below Visual But in X-axis i want to see only Years and data lable show the project Duration same like below visual. only Change in X-Axis I want to see the years.WhatsApp Image 2023-05-30 at 10.51.27 PM.jpeg

 

I want outpul like below Image 

WhatsApp Image 2023-05-31 at 2.02.18 PM.jpeg

1 REPLY 1
MFelix
Super User
Super User

Hi @Girish_123 ,

 

Don't know how you have the information and the data to give the result above but taking the data you send out I created a column with the duration in year has a decimal.

Duration Total = DATEDIFF('Table'[Start Project Date ], 'Table'[End Project Date ], MONTH) / 12 

MFelix_0-1685607550724.png

When I place this on the chart the X-axis got the values:

MFelix_1-1685607677544.png

The axis by default adjust to the size of the data and of the visualization and that is why you don't get all the numbers but it's a similar visualization.

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.