Sorting a matrix column containing strings and percentages

Create a another column

If the value "Inconsistent" then set it to a high maximum value

else set it to the column value

Then go into the data model and change the "sort by" for your colum by the new column.

Learn how here https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column

We are unpaid volunteers and you have got free expert help which took a lot of effort.
This solution works and does exactly what you asked.
So please quickly click the [accept as solution] and the thumbs up button to leave kudos.
If you need to change or extend your request then please raise a new ticket.
One question per ticket please !
You will get a quicker response and each volunteer solver will get the kudos they deserve.

If you quote speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.

However I decline to help impolite lazy members twice who ask misleading or incomplete questions and then dont accept the correct soltion.

Please now click the [accept as solution] and the thumbs up button. Thank you