I need help Sort column Contains numbers and text in Power BI

[HAMZA_07]

I need help sorting data in Power PI like the original data. I tried to use the index, but it didn't work. I'll put the pictures below for clarification :

this is the original data

and this is The result in power bi

Not only are they not properly sorted, but a complete raw is missing :

Help please this is important to me

[Barthel · Accepted solution]

Hey @HAMZA_07,

Add an Index column to the table:

Add the Index column to your table visual and sort the data based on it.

You can then hide the Index column by minimizing its width (sliding).

[HAMZA_07]

Thank you, you're awesome 😊