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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.