Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 a...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

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