Skip to main content

Power BI

Needs Votes

Customize fields list ordering

Vote (565) Share
Ian Bennett's profile image

Ian Bennett on 17 Feb 2017 08:50:54

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.

Comments (77)
Ian Bennett's profile image Profile Picture

Linda Sarace on 06 Jul 2020 00:05:38

RE: Customize fields list ordering

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

Ian Bennett's profile image Profile Picture

Eli Kleinberger on 06 Jul 2020 00:03:52

RE: Customize fields list ordering

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!

Ian Bennett's profile image Profile Picture

Nate Brunner on 06 Jul 2020 00:03:27

RE: Customize fields list ordering

Let's go Microsoft.

Ian Bennett's profile image Profile Picture

Power BI User on 06 Jul 2020 00:01:16

RE: Customize fields list ordering

Please implement. Even the Pivot table in Excel has this basic feature.

Ian Bennett's profile image Profile Picture

Thomas on 06 Jul 2020 00:01:06

RE: Customize fields list ordering

Please implement this. We need to organize the fields as per our business logic and not in alphabetic order

Ian Bennett's profile image Profile Picture

Power BI User on 05 Jul 2020 23:59:48

RE: Customize fields list ordering

Please add this. Absolutely essential!

Ian Bennett's profile image Profile Picture

William S Thomas on 05 Jul 2020 23:59:38

RE: Customize fields list ordering

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.

Ian Bennett's profile image Profile Picture

Power BI User on 05 Jul 2020 23:58:53

RE: Customize fields list ordering

This is a standard is just about every tool I've used. why microsoft is lagging on this? its a simple option.

Ian Bennett's profile image Profile Picture

TEEGEE on 05 Jul 2020 23:58:53

RE: Customize fields list ordering

How has this still not been implemented 2.5 years after being requested?

Ian Bennett's profile image Profile Picture

Power BI User on 05 Jul 2020 23:56:48

RE: Customize fields list ordering

I also fully agree on that.