Short month names in Column Headers and in Charts Axis

[Anonymous]

Hi

Kindly let me know how can i make the months name in short

Eg: January -> Jan

Thanks

[Dangar332]

hi, @Anonymous 

add a column to your table with the following formula:

Short_Name = Format (Table[Date], "mmm")

Then use this column as your axis.

[Anonymous]

Hi,

Thank you. Its working.

How can I sort in a proper order? Like Apr, May, Jun

Thanks

[Dangar332]

HI, @Anonymous 

first short axix according to month
then short according to A-Z as above image

[Anonymous]

Hi,

 I couldnt see only Month option here.  Kindly check

Thanks

[Dangar332]

Hi, @Anonymous 

use hierarchy instead of different field

[Anonymous]

Thank you. Its woring now. I have sort the Month column using Month num

Again Thank you a lot!!