Forum Discussion
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
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 💡
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.
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 💡