topic Re: For Sort Sprint field as sprint1,sprint2..n in DAX Commands and Tips

For Sort Sprint field as sprint1,sprint2..n

Vkd6600 — Wed, 18 Jan 2023 13:39:16 GMT

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

Re: For Sort Sprint field as sprint1,sprint2..n

Anonymous — Wed, 18 Jan 2023 13:53:49 GMT

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!

Re: For Sort Sprint field as sprint1,sprint2..n

olgad — Wed, 18 Jan 2023 13:54:50 GMT

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