cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vkd6600
New Member

For Sort Sprint field as sprint1,sprint2..n

Hi ,I have synario in power bi like we have sprint field in sprint view ,here we have values like Sprint 1, Sprint 2, Sprint 3 ,sprint 31,sprint 4, sprint 5 but o want the sprint order like sprint1,sprint 2,sprint 3 , sprint 4, sprint 5....31,32 like this how resolve this

1 ACCEPTED SOLUTION
olgad
Solution Sage
Solution Sage

Hi There,
in Power Query, duplicate sprint column, split by delimiter. the number column rename Index data type whole number

olgad_0-1674049909969.png

olgad_1-1674049980458.png

olgad_2-1674050064709.png

 

then pick sprint and sort by index column


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

2 REPLIES 2
olgad
Solution Sage
Solution Sage

Hi There,
in Power Query, duplicate sprint column, split by delimiter. the number column rename Index data type whole number

olgad_0-1674049909969.png

olgad_1-1674049980458.png

olgad_2-1674050064709.png

 

then pick sprint and sort by index column


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
shreyamukkawar
Resolver II
Resolver II

Hi @Vkd6600 ,

 

I have tried to answer your question. Let me know if it works for you.

 

Created a new coloumn as

Sprint no = RIGHT(Sheet1[Sprints],2
applied ascending sorting to sprint no so it will apply to spirint column as well.

shreyamukkawar_0-1674049916351.png

 

Best Regards,
Shreya

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

 

Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.