How to change the granularity of date in X-axis of Gantt chart in Power BI

[Anonymous]

Hello All, 

I am currently working on a Gantt chart (MS Corp's Gantt) for a dashboard I am creating. However, I want to change the date granularity so that the full timeline can show on my Gantt, without the need for major scrolling (see below):

 

If my Gantt has a smaller date range (showing every few months) it will look a lot cleaner. 

Any idea how to do this? Please let me know, thank you!

[Anonymous · Accepted solution]

Hi  @Anonymous , 

I have a test on my Gantt chart in my side. I find that we can change the granularity of date in X-axis in "Date type".

Power BI will only expand the X axis when I select low level date type like select hour from day. If select high level date type like year, it won't remove the scrolling. 

 

It seems that your requirement is not supported in gantt chart.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Please explore, if option to use as project plan can help

Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs