Remove day of week on Gantt Chart?

[samanthamirae]

Hi,

Is there any way I can remove the day of the week on the Gantt Chart? As shown in the screenshot, I'd like to remove the "Fri," "Tue," and "Sat" etc. and just have it be the month and year, ideally. Thank you!

 

[v-yulgu-msft · Accepted solution]

Hi @samanthamirae,

By default, it is not able to remove the weekday from date field. As a workaround, you can create a calculated column by formatting the original date field.

Column = FORMAT(Test3[Date],"MMM DD YYYY")

Regards,

Yuliana Gu

[Anonymous]

Hi @samanthamirae

In Visualizations Tab -> Fields tab -> for the date column, you would have selected date hierarchy. You can delete the day from there , it will be remoed from the chart.

Thanks

Raj

[samanthamirae]

Thank you for your reply Raj. I am trying this but only 'Year' shows up as date hierarchy. I'm assuming Gantt chart only supports year?