Forum Discussion
Solved
How to make x-axis in date order rather than based on value
I need help to correct my x-axis from being based on line value rather than in date order. How do I change?
In the ellipsis in the top right corner of the chart you should be able to select the sort order. The issue may be that your x axis is not a date, but a surrogate date.
MattAllington
Community Champion
Community ChampionIt looks like this column you are sorting on is Text. If you want it to sort in date order, you need to convert the column to a date fromat.
Prabhu_MDU
Advocate I
Advocate IHi MattAllington,
Thanks for your kind suggestion, Actually, I have got it done in the way I know.. (may be it is stupid.. )
from the Power Query window, I selected the "Calendar Month" column and make the column to get sorted by the "MonthSort" column.
This approach worked for me.. just to share this, who knows, this may help someone else..
Once again, thans for your time and reply..