topic Re: Short month names in Column Headers and in Charts Axis in DAX Commands and Tips

Short month names in Column Headers and in Charts Axis

Anonymous — Mon, 27 Nov 2023 11:03:59 GMT

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

Eg: January -> Jan

Thanks

Dangar332 — Mon, 27 Nov 2023 11:15:55 GMT

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 — Mon, 27 Nov 2023 11:32:37 GMT

Hi,

Thank you. Its working.

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

Thanks

Dangar332 — Mon, 27 Nov 2023 11:38:02 GMT

HI, Anonymous

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

Anonymous — Mon, 27 Nov 2023 11:47:39 GMT

Hi,

I couldnt see only Month option here. Kindly check

Thanks

Dangar332 — Mon, 27 Nov 2023 13:30:57 GMT

Hi, Anonymous

use hierarchy instead of different field

Anonymous — Mon, 27 Nov 2023 13:35:45 GMT

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

Again Thank you a lot!!