Wrong months order in column chart

[vahrameev]

Hi

I'm trying to visaulize data from last yoer and current year, but months in my chart are in the wrong order.

Need to be sorted by year also (like this: December January February), but 

Example pbix-file here: https://1drv.ms/u/s!ApMveMy2oLCRhJpgk_DTzLKydDxHFg?e=mnBv11

Looks like I need to uncheck something ore enable an option for a correct order, but can't find the solution.

[ryan_mayu]

@vahrameev 

please try to use yyyy/mm or other column with year value in axis.

[vahrameev]

thank you for your suggestion

I've created a new table to test it, but I'm still seeng the same "wrong" month order

what am I missing?

[ryan_mayu · Accepted solution]

@vahrameev 

Column = year('Table'[Column1])&FORMAT('Table'[Column1],"mmm")

add the new column to x-axis

[vahrameev]

got it ryan_mayu

thank you!