Sorting a table hides a record

[jpers36]

I have a table filtered down to a single row.  When sorted ascending the row does not appear.  When I change to sorted descending the row appears.

[v-nmadadi-msft]

Hi @jpers36 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[v-nmadadi-msft]

Hi @jpers36 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @jpers36 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft · Accepted solution]

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

[DataVitalizer]

Hi @jpers36 

It seems like your row might have a null or blank value that's being pushed to the bottom in ascending order and also check the column for any missing values and ensure the correct data type is set.

Could you provide a sample of the data you're working with? It would help me give you a more accurate solution for sorting the row correctly.

Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡

🟩 Follow me on LinkedIn

[jpers36]

I'm not sure what you mean by "being pushed to the bottom".  There is no bottom, it's just a single row.

I also don't know what you mean by "missing values".  The client column has a value for the row, as can be seen in the image.

The datatype for the Client is string, so that looks correct.

I could attempt to anonymize the data and simplify the report for sharing, but that could take significant time.

[DataVitalizer]

@jpers36 since the visual isn’t behaving as expected, you’ll need to go through the checklist in the Data Model rather than the visual itself. If the issue persists, providing a data sample would help me investigate further.

Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡

🟩 Follow me on LinkedIn

[jpers36]

I'm still not following what you're saying.  By "checklist" do you mean your hypotheses in your previous comment?  If so, does that mean you're saying that a blank or null client, even if filtered out, can have an impact on the visual?  I am filtering down to this single client based on client name.

[DataVitalizer]

In your case @jpers36 providing a sample would be helpful in identifying and fixing the issue

Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡

🟩 Follow me on LinkedIn