Forum Discussion

margheritaiacob's avatar
margheritaiacob
Frequent Visitor
4 years ago
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
Need Help
  • NickolajJessen's avatar
    NickolajJessen
    4 years ago

    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.

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

I am not sure without seeing your dataset, but I assume you can try to sort week of year column by weekenddate column in the same table.

If you do not have a weekenddate column in the same table, try to create this in Power Query Editor or by DAX formula (Calculated Column), and then sort week of year column by weekenddate column.

Thank you.