Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

undefined

Hi,

 

I have a custom column created & it is the below:

 

=if(YEAR(Task[UpdatedDate])<>1970,SWITCH (
TRUE (),
Task[UpdateAge_Days] <1 , "<1 Day",
AND(Task[UpdateAge_Days] <=2 ,Task[UpdateAge_Days] >=1),"1-2 Days",
AND(Task[UpdateAge_Days] <=3 ,Task[UpdateAge_Days] >2),"3 Days",
AND(Task[UpdateAge_Days] <=5 ,Task[UpdateAge_Days] >3),"4-5 Days",
AND(Task[UpdateAge_Days] <=10 ,Task[UpdateAge_Days] >5),"5-10 Days",

Task[UpdateAge_Days] >10 ,">10 Days "
))

 

 

I want to sort as per above,but it shows the below:

<1day

>10days

1-2days

3days

4-5days

5-10days

 

I want it to be like this:

<1day

1-2days

3days

4-5days

5-10days

>10days

 

 

Please help in sorting the above

4 ACCEPTED SOLUTIONS
Anonymous
Not applicable

@amitchandak @onurbmiguel_ @lbendlin  & other who are seeing

 

Please help

View solution in original post

Read about "Sort a column by another column".

 

Your code can be cleaned up:

=SWITCH (
TRUE (),
YEAR(Task[UpdatedDate])=1970,BLANK()
Task[UpdateAge_Days] <1 ,"<1 Day",
Task[UpdateAge_Days] <=2,"1-2 Days",
Task[UpdateAge_Days] <=3,"3 Days",
Task[UpdateAge_Days] <=5,"4-5 Days",
Task[UpdateAge_Days] <=10,"5-10 Days",
">10 Days "
)

View solution in original post

hi @Anonymous 

You need to creat two columns 

  • the first one , as @lbendlin  have write  , with the efective label that you want: 
Label =
SWITCH (
TRUE (),
YEAR(Task[UpdatedDate])=1970,BLANK(),
Task[UpdateAge_Days] <1 ,"<1 Day",
Task[UpdateAge_Days] <=2,"1-2 Days",
Task[UpdateAge_Days] <=3,"3 Days",
Task[UpdateAge_Days] <=5,"4-5 Days",
Task[UpdateAge_Days] <=10,"5-10 Days",
">10 Days "
)

 

  • and the ohther one for the sort: 
Label (sort) =
SWITCH (
TRUE (),
YEAR(Task[UpdatedDate])=1970, 99,
Task[UpdateAge_Days] <1 , 1,
Task[UpdateAge_Days] <=2, 2,
Task[UpdateAge_Days] <=3, 3,
Task[UpdateAge_Days] <=5, 4,
Task[UpdateAge_Days] <=10, 5,
6
)

 

like this you can use column "Label (sort)" to sort the first one. 

Any other question please ask. 

 

Best regards

Bruno Costa | Impactful Individual

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!

 

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


View solution in original post

hi @Anonymous 

Does my suggestion work?
If yes then please accept my answer have solution thanks

 

Best regards

Bruno Costa | Impactful Individual

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Thank you all for your help!

Anonymous
Not applicable

@amitchandak @onurbmiguel_ @lbendlin  & other who are seeing

 

Please help

hi @Anonymous 

You need to creat two columns 

  • the first one , as @lbendlin  have write  , with the efective label that you want: 
Label =
SWITCH (
TRUE (),
YEAR(Task[UpdatedDate])=1970,BLANK(),
Task[UpdateAge_Days] <1 ,"<1 Day",
Task[UpdateAge_Days] <=2,"1-2 Days",
Task[UpdateAge_Days] <=3,"3 Days",
Task[UpdateAge_Days] <=5,"4-5 Days",
Task[UpdateAge_Days] <=10,"5-10 Days",
">10 Days "
)

 

  • and the ohther one for the sort: 
Label (sort) =
SWITCH (
TRUE (),
YEAR(Task[UpdatedDate])=1970, 99,
Task[UpdateAge_Days] <1 , 1,
Task[UpdateAge_Days] <=2, 2,
Task[UpdateAge_Days] <=3, 3,
Task[UpdateAge_Days] <=5, 4,
Task[UpdateAge_Days] <=10, 5,
6
)

 

like this you can use column "Label (sort)" to sort the first one. 

Any other question please ask. 

 

Best regards

Bruno Costa | Impactful Individual

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!

 

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


hi @Anonymous 

Does my suggestion work?
If yes then please accept my answer have solution thanks

 

Best regards

Bruno Costa | Impactful Individual

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


Read about "Sort a column by another column".

 

Your code can be cleaned up:

=SWITCH (
TRUE (),
YEAR(Task[UpdatedDate])=1970,BLANK()
Task[UpdateAge_Days] <1 ,"<1 Day",
Task[UpdateAge_Days] <=2,"1-2 Days",
Task[UpdateAge_Days] <=3,"3 Days",
Task[UpdateAge_Days] <=5,"4-5 Days",
Task[UpdateAge_Days] <=10,"5-10 Days",
">10 Days "
)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.