How to sort start of week column in my date table?

[ironboy0418]

I am trying to sort start of week column using the week rank calculated column I've created. However, I am encountering this error:

Start of week dax:

Week Rank dax:

[FreemanZ]

hi @ironboy0418 

what do you mean by "sort start of week"?

[ironboy0418]

Sorry. I am actually using it in my line chart, so that it will be sorted by start of week:

Everytime I use sort by column, it gives me the above error:

[FreemanZ · Accepted solution]

hi @ironboy0418 

seems no need for the rank column, try to rewrite your column like:

Start of Week =

[Date]-WEEKDAY([Date])

Then you shall be able to sort by the column itself. Or?

[ironboy0418]

Thank you @FreemanZ the start of week column is actually a text data type that's why I am encountering the error. Appreciate the help!

[FreemanZ]

Indeed, texts sort alphabetically. Number and Date are sorted numerically.