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.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
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.