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 
AilleryO's avatar
AilleryO
Memorable Member
3 years ago

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
    3 years ago

    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