Forum Discussion
Solved
Calender weeks
Hallo, I want to make a filter for the Calander weeks. The problem is that PowerBI is sorting it from 1, 10, 11, ..., 2, 21, 22 instead of 1, 2, 3, .. 9, 10. How can i change that?
It might be because your data type is text. You can either convert the data type to number or create a column which is having week numbers and having data type as whole number and mark that new column as a sort column.
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
It might be because your data type is text. You can either convert the data type to number or create a column which is having week numbers and having data type as whole number and mark that new column as a sort column.
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c