Graph Months not ordered

[Anonymous]

Hi all,

So I am in the process of ordering the months in a graph. However, Power Bi just decides to either order them alphabetically or in other orders. I tried various methods such as creating an extra month number column as suggested by numerous sources but that did not work.

As a last resort I tried to just put a number in front of the month but even then power Bi just decides to order it incorrectly. 

See screen (I selected order by month and tried both ascending and descending)

Any idea?

Thanks:)

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Create a month number column based on the month name, then select the month name column, click sort by column button, and select sort by month number. Then drag the month name field back into the graph.

Month number = MONTH(Sheet2[Date])

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Anonymous 

To get the months sorted in the order of Jan, Feb, Mar . . . and so on, you need to create a sort column that represents the month number and sort the month name by that column:

Refer to this sort video: https://www.youtube.com/watch?v=NlX7Cp2P0d4

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[Anonymous]

Hi @Anonymous ,

Please click on the three dots (ellpses) in tp right corner of the chart. 

And choose sort by months.

[Anonymous]

Hi,

 Off cour I did that, still shows it wrong. It takes the first number of 10-11-12 and counts it before 2 lol. So that doesnt work. 

[Suundumused]

For this to work, I needed to ensure that the Numeric Month column was in Integer format. Mine was in text format, which is why it wasn't working.