Forum Discussion

lennyt99's avatar
lennyt99
Helper I
3 years ago
Solved

help! sort slicer chronologically

I have no idea why my fiscal yweek slicer isn't going from 1-53 in order. Can someone please help?

The fiscal month starts october...

 

THanks!

Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , lennyt99 

    This happens because your field is in a text format.Power BI sorts you in text format.

    If you want to sort by Date , you can select the filed , and click "Sort By Column" in "Column Tools" , like this:

    My test data :

    The result is as follows:

    For more infomation, you can refer to this document:

    Sort one column by another column in Power BI - Power BI | Microsoft Learn

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

2 Replies

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi , lennyt99 

    This happens because your field is in a text format.Power BI sorts you in text format.

    If you want to sort by Date , you can select the filed , and click "Sort By Column" in "Column Tools" , like this:

    My test data :

    The result is as follows:

    For more infomation, you can refer to this document:

    Sort one column by another column in Power BI - Power BI | Microsoft Learn

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly