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

View all the Fabric Data Days sessions on demand. View schedule

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
wsthomasphd
New Member
Currently the FIELDS area lists fields by alphabetic order within a data object (or EXCEL file). There is no option to display fields in the order they appear in the data object or in the EXCEL file. This makes it more difficult to find fields because they are out of order and scrambled when compared to an Excel workbook or data file. Therefore, Provide the option to list fields by their order within worksheets and other objects OR alphabetically.
szimmer11
New Member
Please add this. Absolutely essential!
thomasv1
New Member
Please implement this. We need to organize the fields as per our business logic and not in alphabetic order
josemiguel_salv
New Member
Please implement. Even the Pivot table in Excel has this basic feature.
eli5
New Member
Original order should be the default - other custom orders should be optional. I you don't give the user options, at least let us keep our original order please!
nbrunne1
New Member
Let's go Microsoft.
linda_sarace1
New Member
When building reports (what we call "thin" reports) in Power BI Desktop from an existing data model (used Power BI Dataset option for the Get Data to retrieve a data model), we need the table/query structure from the model to be the way the table/query structure in presented in the Fields section within Power BI. For example: In Query Editor within a data model a table/query structure may look like this: Order Subject Area [5] Order line Unified Order Standing Order Unified Order Line Order Reconciliation Shipment Subject Area [3] Shipment Number Shipment Status Shipment Reconciliation When this model is sourced into Power BI Desktop, the Fields panel should present the structure just as it appears above. At current it simply places the queries in alphabetical order
ajgrindle
New Member
just started getting into using power BI and this nuance is making me want to look elsewhere for creating reports. this increases the amount of time i have to spend creating reports because i constantly have to look back at my original table to confirm the order of fields. Microsoft, why are you applying any type of sort here. This just seems silly. If you think you are being helpful then you are very wrong.
missyjar
Advocate I
Some time back, MS added the ability to group the queries in the Query Builder - this has helped tremendously. BUT, we need to have these groupings ("Folders") carry into the report-building experience. In a model that has dozens of queries, we need something more than alphabetical order as the organization of them in the "fields" pane.
alain_debecker
New Member
Typically the type of distinctive feature between professional and amateur software. Please implement asap.