Forum Discussion
Problem with X Asix Sorting Month and Year
Hey guys, i have the following problem:
I have a dataset with a date column with values beginning from 2021-9 to today (formatted as date).
Now when i create a visual with the date on the x - Axis it gets sorted like that
Jan - September - Oktober-November December
But what i need is:
September - Oktober - November - December - January Because (its 2022)
I tried it with Concatenate and formatting it as a whole number and then sort it by that doesnt work.
Any suggestions?
Thanks in advance. I did not find a solution that work for me via the search function.
BR
6 Replies
Hi,
For these type of visualizations I highly suggest using a format that display year and month at the same time. Here is one way to do this in a calendar table:CustomFormat = FORMAT(DATE(YEAR('Calendar'[Date]),MONTH('Calendar'[Date]),1),"MMM-YY")
After you have this kind of column you can sort it e.g. using a column with data like this 2021,12
This will solve your sorting issue and it will make the visualization more readable.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!Hi,
You can add additonal column with number type data and use that to sort your axis. e.g.sort = CONCATENATE(YEAR('Calendar'[Date]),MONTH('Calendar'[Date]))
