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 - Ax...
Hi Anonymous
Change the format of your date to (yyyy-mm) and add the date in column chart as a hierarchy .
The final result is as shown :
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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!
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!