Problem with sorting date column

[dwauer]

Hello everyone,

I have a problem with sorting by date.

When I sort in ascending order, it shows me some values ​​incorrectly.

The column is set as a date column.

Look at the picture, data from April comes first, even though March was chosen as the earliest date.

What could be the reason?

[PijushRoy · Accepted solution]

Hi @dwauer 

Unable to reproduce the same in my use cases, if it is date datatype and you select ascending order, it should show as per proper order.

Please check if you are using sortby for other columns or not

Please share sample pbix file link (google drive, onedrive, dropbox) 

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[dwauer]

I found the problem.

The column was actually formatted as text and not as a date.
Somehow it didn't take over when I changed it.

It works now.

Thank you for your help!

[PijushRoy]

You are welcome @dwauer