Solved: Calender weeks

Elijabrnc · ‎09-14-2023

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?

nirali_arora · ‎09-14-2023

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

View solution in original post

nirali_arora · ‎09-14-2023

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