EOMONTH between Charts and Table

[RanjanThammaiah]

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.

[v-jingzhang · Accepted solution]

Hi @RanjanThammaiah 

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.

[amitchandak]

@RanjanThammaiah , Hope you have done like

Month year = format(eomonth([Date], 0), "mmm-yyyy" )

0 for current month end date

[RanjanThammaiah]

This is how i have been added the month end date, is there anything wrong?