Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Customize fields list ordering

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.
Status: Needs Votes
Comments
kunden_arun
New Member
allow fields to be ordered the same as the source query rather than alphabetical.
tborowski
New Member
When you query into Power BI the columns stay in order for the data view. However, the Fields Pane sorts the column titles (headers) alphabetically. This is slightly problematic as it creates inconsistencies in how the data is organized. Not a big deal, but it would be nice if things would all stay sorted the same way.
Jesse_Glidden
New Member
Seems like this would be easy to do. The alphabetical list is super-annoying and unnecessarily requires me to use my recollection of the alphabet.
mahbod19
New Member
the default design is studid. it should be based on original order as it loads into the query. the ideal case is to have an option in the panel.
plehmann2018
New Member
This is really super-annoying. Users complain a lot because in Excel PowerPivot it works by setting a checkbox - alphabetic order, data source order - in the option window.
fred_stimler
New Member
Please use the sort order of the source - I can never find my fields
Chayakiran
New Member
It would be helpful to have the Field pane carry over the structure of the Queries pane in the Edit Query view. This allows a report writer to easily navigate the field pane grouped together in logical groups. Thanks.
ferronato_guto
New Member
I can't believe this can't be done yet. Often I work with primary data with 100+ fields extracted straight from databases which need to be constantly updated from PBI (I won't download the whole database everytime, so I can't do the column prefix workaround). Most databases have a logical order in their fields. The alphabetical ordering makes me lose so much time looking for each field because it's extremely ILLOGICAL.
natrembl
New Member
I've used the software for 20 minutes and run into this immediately. This is appalling default behavior. Yikes.
Rene_DiazBrans
New Member
Please implement. Even the Pivot table in Excel has this basic feature.