Sort text column

[Anonymous]

Is there a way to properly sort this column. I tried adding another column for sorting it by converting it to a whole number but it returns a circular dependency error. 

Thank you!

[v-yangliu-msft]

Hi  @Anonymous  ,

Here are the steps you can follow：

1. You can add a Value in front of the function of this week.

week = VALUE(WEEKDAY('Table'[date]))

2. Select the week column, and then click to select Sort ascending to sort

3. Result:

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , Create new columns

Week 1 =[week]

Week sort = <Sort code>

Sort week 1 on week sort and use week 1 in visual

Refer my video on this https://www.youtube.com/watch?v=KK1zu4MBb-c