topic Re: Remove 2022 from Date and show all dates on X-axis in DAX Commands and Tips

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

Lyle — Wed, 06 Apr 2022 12:12:49 GMT

Good day

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

Thanks in advance !

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

Pragati11 — Wed, 06 Apr 2022 12:35:34 GMT

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.

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

v-kkf-msft — Tue, 12 Apr 2022 05:50:08 GMT

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.

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

Lyle — Tue, 19 Apr 2022 12:52:46 GMT

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