Sorting X-axis in line and clustered column chart

[Stevenrizado]

Hi Datanauts,

I'm trying to show a line and clustered column chart sorted by month, which I tried to realize by plotting the months as "18_01", "18_02" etcetera. However, when I create the graph, this is the result:

It appears Power BI decides to sort the X-axis by largest samples. I tried to 'sort by column', but that was not the right move. Underneath is the Excel sheet I created for use in Power BI.

What is in your opinion the best / easiest way to make sure I show the same data, but sorted by month?

Thanks in advance,

Stefan Raets

[kaushikd · Accepted solution]

Create a new column and extract the month only like(01..02..03) exclude the Year Part. Then Sort the Maand(i.e your column name) by New Column you have created(In Modelling Tab). This will fix your problem, if you still unable to fix the problem just share the pbix file with us we will fix that.

[Stevenrizado]

Thanks kaushikd,

It did the trick!

[kaushikd]

Once you create the new column then follow this link

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-butto...