Forum Discussion
Sort text column
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!
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
2 Replies
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
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.