Forum Discussion
Graph Months not ordered
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:)
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.
5 Replies
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.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.
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 🙂
