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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
po
Post Prodigy
Post Prodigy

Gantt chart end date not working/reflecting actual data

Hi,

 

using microsoft custome visual gantt chart and simple example below

 

1 row in table

 

task, start_date, end_date

task1, 01/01/1900 12:00:00, 01/01/01/1900 14:00

 

put task in task_name, start_date in start_date well, end_date in edn date well and chnage data type to hour

 

rather than bar shoiwng jus hours between 12 and 14 shows entire 24 hours as thinks end date is 02/01/1900 fro soem reason.

 

Anyone seen this before know how to resolve?

 

Thanks

 

gantt.JPG

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @po ,

 

there is an option on the general option (duration unit) that you need to set also for hours:

 

MFelix_1-1620907231177.png

 

MFelix_2-1620907246318.png

 

 


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



View solution in original post

4 REPLIES 4
MFelix
Super User
Super User

Hi @po ,

 

there is an option on the general option (duration unit) that you need to set also for hours:

 

MFelix_1-1620907231177.png

 

MFelix_2-1620907246318.png

 

 


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



Hi,

 

Thanks that works.

 

Just wondering is there an option to chnage the sclae of the time e.g to show in 2 hourley increments.

 

as can see below means need to scroll?

 

scale.JPG

 

Thanks again.

 

 

Hi @po ,

 

To what I can see there is no such option.


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



Thanks for update

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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