Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

the column seems to be in a text format. When i change it to date it sometimes messes up the year and tooks for every row 2022.

ValtteriN's avatar
ValtteriN
Community Champion
4 years ago

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]))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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