Sorting help

[PSan1979]

Hi Folks,

I am struggling to sort in order. please help.

#DaysBucket =

SWITCH (

TRUE (),

[DateDiff] <=1,"<0",

[DateDiff] >1 && [DateDiff] <= 30, "1-30",

[DateDiff] >30 && [DateDiff] <= 60, "31-60",

[DateDiff] >60 && [DateDiff] <= 120, "61-120",

[DateDiff] >120 && [DateDiff] <= 180, "121-180",

[DateDiff] >180 && [DateDiff] <= 240, "181-240",

[DateDiff] >240 && [DateDiff] <= 366, "241-366",

"Unknown"

)

[Tahreem24 · Accepted solution]

@PSan1979 ,

Create one more switch column for sorting:

Sorting COlumn =

SWITCH(Table[Bucket],"<0",1,

"1-30",2,

"31-60",3,

"61-120",4,

"121-180",5,

"181-240",6,7)

[v-easonf-msft · Accepted solution]

Hi , @PSan1979 

It seems that  field "DateDiff"   is  a  calculated column or a measure?

Please sort column DateDiff   in ascending order first.

Then  select and  sort  the column "DaysBucket2" by column" DateDiff", the result will show as below.

Sample pbix attached

Best Regards,
Community Support Team _ Eason

[Tahreem24]

@PSan1979 ,

Or you can sort the bucket column based on SOrting COlumn which is created in my above post.

Go to Data tab (just above the relationship tab)  --> select BucketRange column --> go to "Column tool" menu --> Sort by COlumn option --> and choose "Sorting Order" column which just created.

[amitchandak]

@PSan1979 , I the same ways create a sort column with sequence 1,2,3 

2 #DaysBucket =
SWITCH (
TRUE (),
[DateDiff] <=1,1,
[DateDiff] >1 && [DateDiff] <= 30, 2,
[DateDiff] >30 && [DateDiff] <= 60, 3,
[DateDiff] >60 && [DateDiff] <= 120, 4,
[DateDiff] >120 && [DateDiff] <= 180, 4,
[DateDiff] >180 && [DateDiff] <= 240, 6,
[DateDiff] >240 && [DateDiff] <= 366, 7,
8
)

Or give space in names to sort in a particular order. In first give 6 space, 2nd one give 5 space

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Tahreem24 · Accepted solution]

@PSan1979 ,

Create one more switch column for sorting:

Sorting COlumn =

SWITCH(Table[Bucket],"<0",1,

"1-30",2,

"31-60",3,

"61-120",4,

"121-180",5,

"181-240",6,7)