Sorting a table hides a record

Hi jpers36 
Thanks for reaching out to the Microsoft fabric community forum.

1) When Power BI is not sorting numbers correctly, first check that the data type is correct.
The most common cause of this error is a number assigned a non-numeric data type. If they are setup in Power BI as text or a mix of numbers and text it will cause a sorting error. 
2) Check Calculated Columns and Measures. When calculations fail, they can result in null values or errors. Power BI will not interpret these correctly and Power BI will not sort these values. Sometimes they will appear as null or blanks.
3) Sometimes sorting by a column from another table can behave differently due to relationships in the data model. This is more noticeable if the column is linked to a measure or calculated column, since their results depend on the filter context. To check, remove all filters and sort again to see if the row appears in both ascending and descending order.

I hope this information helps. Please do let us know if you have any further queries.
Thank you