For Sort Sprint field as sprint1,sprint2..n

[Vkd6600]

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

[olgad · Accepted solution]

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

then pick sprint and sort by index column

[Anonymous]

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.

Best Regards,
Shreya

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