Forum Discussion
Sorting X-axis in line and clustered column chart
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
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.
3 Replies
- kaushikd
Resolver II
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.
- kaushikd
Once you create the new column then follow this link
Thanks kaushikd,
It did the trick!
