At least as an option, allow fields to be ordered the same as the source query rather than alphabetical. This way they can be put in a logical and consistent order. Obviously, a workaround is to prefix each column name with a number but this is clunky, unattractive and a pain if the columns change often.
78 Comments
- ChristianDiscer
Advocate I
The task pane displays database fields in alphabetical order. Please allow the field list to be displayed in original, or database defined order. - Found a related idea: "Display field names in database, not alpha, order"
- can you order variables in fields section as imported from Excel
- Currently if you set the "Default Field Set" field order in an SSAS Tabular model, it is not utilized by Power BI in the Fields pane. It still only sorts alphabetically.
- When looking at the tables in the Relationships window - and to make new relationships - it would really help to show the fields in alphabetical order. It feels like I'm always going on a scavenger hunt when I'm trying to find a field because I have to scroll thru the entire list looking for it. This can be challenging and time consuming, especially with large tables. Thanks!
- Would really like this to be supported.
- Great Idea, and possibly to group fields together as well?
- SSAS Tabular has a "Table Detail Position" described as "...field ordering that define the default field set when visualizing this table in certain client tools". Surprisingly, Power BI is not such a "client tool". Frankly, quite odd, when you think of how closely related Power BI and SSAS tabular are underneath.
- Cross post https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18355429-use-field-order-as-ordered-in-source-query
- I agree that the 'default' order for "Fields" should be whatever it is in the source. There is a reason the source has the fields in a specific order, so changing it means the 'structure view' to the user has changed. Please keep the order the same by default, and then (maybe) allow changes to be modified to 'sorted A-Z', etc. Many thanks.
