Remove 2022 from Date and show all dates on X-axis

[Lyle]

Good day

I'm trying to remove 2022 from the ETA and show all the days on the X-axis

Thanks in advance !

[v-kkf-msft]

Hi @Lyle ,

Please change the format of the [Month ETA] column to "dd mmmm", and then set the X-axis of the bar chart to the categorical type.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11 · Accepted solution]

HI @Lyle ,

Have you got a date hierarchy on your bar chart?

If you have a date hirarchy then you can drll down to day level and show days on the x-axis. Something like below:

The other way could be just to move the day part from your date column on the x-axis if you don't need a drill-down capability on the chart. Something like below:

Let me know if this is what you are looking for.

[Lyle]

Thanks @Pragati11 ! I changed to using the calendar hierarchy and it's working perfectly. Many thanks