Add short month on x axis, month only

[Anonymous]

Good day everyone ! I tried several methods to Add short month on x axis, month only, but could not find a solution. 

Methods tried :

1. Creating a duplicate date column and setting that column format as "mmm" ---> result : seems to work on tables but on a bar chart, it shows Jan 2021 or"mmm yyyy"

2. Creating a column with this formula : Short_Name = Format (Table[Date], "mmm") ---> result : Month is sorted in ascending order instead of date. e.g. April, August, XXX  instead of Jan, Feb Apr, XXX

Note : The table being used is a date table with continuous dates, created using the CALENDAR() function

Truly appreciate if you could share the solution ! 

[PaulDBrown]

Whenever dates are involved, it is highly recommended that you use a date table with continuous dates covering the range of dates in your model. Once you have created the date table, join the corresponding date fieldsfrom the date table to the data table in a one-to-many relationship. You then use the fields from the date table in your visuals, measures filters etc 

you can create a date table in Power Query or using DAX (CALENDAR() or CALENDARAUTO() functions)

[Anonymous]

Hi @PaulDBrown , thank you for sharing, yes, i agree, i am currently using a date table with continuous dates, using the CALENDAR() function. How can i successfully have short month / "mmm" on the x-axis of a bar chart ?

[PaulDBrown · Accepted solution]

In your date table, create a new column for "month number" using MONTH(date table[date]). You then select the month column in your date table and in the ribbon select "Sort by column " and set the month number column as the sorting order. You can then use the month column in your visuals and they will be in the correct order

[Anonymous]

Hi @PaulDBrown, this solution works like a charm ! Simple steps but workable logic.

Thank you and take care !