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 a...
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.
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.
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.