Forum Discussion

Chandrashekar's avatar
Chandrashekar
Resolver III
3 years ago

Sort by Column

Hello,

 

How to sort week name by column wise. (Attached sample data).

Sample data: PBIX 

Regards,

Chandrashekar B 

2 Replies

  • AilleryO's avatar
    AilleryO
    Memorable Member

    Hi,

     

    Solution Number 1 : If you have a column with only week number (and type is numeric) you can use this column to sort your column (Week-1).

    Solution Number 2 : You use a 2 digits number for week numbers and it will work (Week-01 instead of Week-1)

     

    Let us know if ot works

    • Chandrashekar's avatar
      Chandrashekar
      Resolver III

      Hello,

       

      it worked when i use Week-01 format. Now is it possible to sort in reverse order.

      Ex: Week-52,Week-51,Week-01 

      Sample Data: PBIX File 

      Regards,

      Chandrashekar B