Forum Discussion
Helper IIstandard order in table visual?
Hi mostho
The behavior you're observing with the Power BI table visual is related to the default sorting behavior that Power BI applies when there is no explicit sorting order set by the user. By default, Power BI often tries to sort by integer or key columns, alphabetical or natural order, and even the column order in the data model.
As you mentioned, you can customize the sorting behavior by selecting a specific column. However, there is no explicit documentation detailing a "standard order" for Power BI tables. We have a guide for visualization developers, which provides insights into custom sorting and how to control it effectively.
Sorting options for Power BI visuals - Power BI | Microsoft LearnHi mostho
When you drag the fields into a table visualization, the initial sorting is done according to the KEY / whole number column. The reason for this is an attempt to create some sort of logical order from the perspective of the 'engine.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Helper II- Take a table visual
- Put some columns of (any) table of your model in this visual
- Do not define a sort order
Question: In which order do you see the records in the table visual?
My observation is that the records are sorted in a specific order although i did not define a sort order. And i want to understand this bahaviour.
Super UserHi mostho
When you drag the fields into a table visualization, the initial sorting is done according to the KEY / whole number column. The reason for this is an attempt to create some sort of logical order from the perspective of the 'engine.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly