Sort a line chart by the Y axis in Power BI

Hello,

I am trying to visualize some data on a graphic. I need to show some values according to the depth that is on the y-axis.

I have followed the instructions of the page below:

https://www.daytodatastuff.co.uk/blog/sort-a-line-chart-by-the-y-axis-in-power-bi

I sorted in power query the list according to depth and then added an index column and then tried to sort my values by Index. I still get the same error: We can’t sort the 'Verschiebung' column by 'Index'. There can't be more than one value in 'Index' for the same value in 'Verschiebung'.

I have to mention though that my 'Verschiebung' column was generated in DAX and not in the power Query, so when I want to transform the data in Power query, I do not see the column 'Verschiebung'.

But honestly, I do not think this should be a problem because, the calculated column 'Verschiebung' follows the rows of column 'depth' which is existing in power query.

Can you help me here?

Thank you for your time and consideration.

Best regards,

Maya Elias