Forum Discussion
Helper VEOMONTH between Charts and Table
Hi Team,
Can some one help me why the monthe name is showing difference between Table and Chart. I have calculated the month using the EOMONTH function. The November Month data is showing as December in Charts which is wrong.
When a column is of date type and on x axis of a column chart, it will choose Continuous type for x axis by default and adjust axis text automatically instead of showing the exact values in the column.
To change the axis text, one workaround is to change x axis type from Continuous to Categorical. Another is to change this column from Date type to Text type manually (or using Format function as Amit has suggested because Format function returns value in Text type too). Both will display exact column values on the axis.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
3 Replies
- amitchandak
Super User
RanjanThammaiah , Hope you have done like
Month year = format(eomonth([Date], 0), "mmm-yyyy" )
0 for current month end date
RanjanThammaiahThis is how i have been added the month end date, is there anything wrong?
v-jingzhangCommunity Support
When a column is of date type and on x axis of a column chart, it will choose Continuous type for x axis by default and adjust axis text automatically instead of showing the exact values in the column.
To change the axis text, one workaround is to change x axis type from Continuous to Categorical. Another is to change this column from Date type to Text type manually (or using Format function as Amit has suggested because Format function returns value in Text type too). Both will display exact column values on the axis.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
