topic Sort by Column in DAX Commands and Tips

Sort by Column

Chandrashekar — Mon, 23 Jan 2023 11:28:24 GMT

Hello,

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

Sample data: PBIX

Regards,

Chandrashekar B

AilleryO — Mon, 23 Jan 2023 11:35:09 GMT

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 — Tue, 24 Jan 2023 04:03:02 GMT

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