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,
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]))
Ok ty! this worked, but now i have on the X-Axis the Sort Value like this:
But for the Dashboard viewers it would be better to have the CustomColumn on the X-Axis. But how can i define X=CustomColumn but sort it with the Sort column?
BTW. The mistake i did was that there was the zero missing for january "01" so i wasnt sorted correctly before by number