Forum Discussion
X-axis formatting in Line chart
I have created a graph like this Please can someone tell me if I can achieve an X-axis like below for the above graph I tried creating in Date table a column with 'MMM-yy' format bu...
Hi Anonymous
The MMM-YY column is stored as text, so a continuous axis is not available. The closest alternative is to create a date column, such as an end-of-month or start-of-month value, for example using EOMONTH('TABLE'[DATE], 0).
Some visuals do not respect the column’s formatting, which is why this is only the closest option. In the example shown, the End of Month column is formatted as MMM-YY, but the visual displays it differently, but instead of just year the X-axis now shows month and year.
I do not want aggregation and neither the EOMONTH is working as it worked @danextian.
But thank you.