How to change end date in gantt chart?

[YunJ]

Hi,

I downloaded a gantt chart in marketplace.

Here is my raw data:

Here, I want to show the end date as 2/23 rather than 2/24, and the minute and second don't need to be shown.

Thanks a lot for your time.

[v-cazheng-msft · Accepted solution]

Hi, @YunJ 

You can try these steps.

1 Set the duration unit as Hours and Duration min as 12 for Gantt visual

2 Set Date format as d for Gantt visual

The result looks like this:

Here is the pbix.

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[YunJ]

Thanks @v-cazheng-msft ! That's exactly what I want. Also I'm wondering is there any document or instruction on Date format in this visual? For example, d means month/day/year in this case.

Thanks again for your time.

[v-cazheng-msft]

I haven't found any document or instruction, I judge it from the json file of the Gantt visual.

This is the part about date format in the json file:

patterns:{d:\"MM/dd/yyyy\",t:\"hh:mm tt\",T:\"hh:mm:ss tt\",f:\"dddd, MMMM dd, yyyy hh:mm tt\",F:\"dddd, MMMM dd, yyyy hh:mm:ss tt\",M:\"dd MMMM\"}

Best Regards

Caiyun Zheng