show in "MMM" in x-axis

[pang22]

Hi,

How to transform the month to show in "MMM" (Jan, Feb) abbreviations and show the corresponding year in the x-axis?

Thanks.

[ryan_mayu · Accepted solution]

@pang22 

you can use FORMAT(date,"mmm")

https://learn.microsoft.com/en-us/dax/format-function-dax?wt.mc_id=DP-MVP-5004616

[Ashish_Mathur · Accepted solution]

Additionally, create a Calendar Table.

[ryan_mayu · Accepted solution]

@pang22 

you can use FORMAT(date,"mmm")

https://learn.microsoft.com/en-us/dax/format-function-dax?wt.mc_id=DP-MVP-5004616

[pang22]

After create to "MMM" format, how to sort the month in correct order?

[ryan_mayu]

create a number column like 202401, 202402, 202403.

=year(date)*100+month(date)

then sort the month name column by the number column

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...