Forum Discussion
Solved
Order problem
Hi, pls I have problem with X-axis order even if I used "Sort axis > week of year > sort ascending", it didn't solve my problem. How could I resolve it? Help me pls
If you're not using a calendar table. You should do that.
Next you go and create a integer version of the yearweek and use Power bi Sort by function.
here is an example but with months in stead. I hope you get the general idea.
Hi, they are sorted alphabetically - you can try formatting your weeknumber as "0#" so that when you have week 6, you get 06, instead of 6 - this would translate to 2022-06 and it will be sorted properly. That's the easiest thing you can do, having a calendar table is always a good approach, as already suggested above.