Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dates stopped sorting in order

Hello,   Today, when working on report everything is going well. Suddenly things stopped work well: My date charts got crazy, they stopped to show up in order. (styczeń- january, listopad- novem...
Need Help
  • Gabriel_Walkman's avatar
    Gabriel_Walkman
    5 years ago

    I've only ever modified my Calendar table in power query, but I'll give it a try by editing BA_Pete's answer for a dax calculated column:

     

    yearMonth = FORMAT([date], "yy") & "-" & FORMAT([date], "MM")

     

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
5 years ago

Hi Anonymous ,

 

Silly question, I'm sure, but have you checked that your chart sorting hasn't been reset to default somehow?

 

Pete

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for your answer!

     

    Yes, I have been trying to do so, trying to google this for an trying different things and options.

    Still not right.

     

     For days, it is working well:

    Btw. month are formatted as date as well as days.