Unable to Sort Column in Correct Order

[Anonymous]

Hello there,

I have some body metrics taken every week. I am trying to create dashboard in Power BI. I created a matrix added parameters in Rows and Dates in Column, Corresponding values in Values. But the Dates inserted in the column section are sorted in a random way I unable to sort them.

[Anonymous · Accepted solution]

Make a copy of the column in Power Query and set the Data Type to Date and then use that column to sort