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

Power BI User on 05 Jul 2020 23:23:44

RE: Customize fields list ordering

At least re-order the fields in fields pane. I would also be helpful to be able to create folders and put the fields in logical blocks, especially for large data sets. Most BI tools have this for ages.

Ian Bennett's profile image Profile Picture

dsdasdasd on 05 Jul 2020 23:22:48

RE: Customize fields list ordering

From the end user prospective, we need to have an option to chose weather or not the columns in the Fields pane should be loaded in the same order as in source

Ian Bennett's profile image Profile Picture

Kerem Yucel on 05 Jul 2020 23:21:11

RE: Customize fields list ordering

Fields should be ordered manually since a-z order may not be logical for finding the right one quickly.

Ian Bennett's profile image Profile Picture

Power BI User on 05 Jul 2020 23:17:50

RE: Customize fields list ordering

Offer to allow the "Fields" to display in the order they appear in the data source, like Excel does with Pivot Table Field lists.

Ian Bennett's profile image Profile Picture

Mike Casey on 05 Jul 2020 23:15:40

RE: Customize fields list ordering

Agree this is a must. All building reference sheets are in the data order not alphabetically. This should be a toggle option in the (...) menu of the fields area

Ian Bennett's profile image Profile Picture

Chris Missel on 05 Jul 2020 23:15:08

RE: Customize fields list ordering

Absolutely a MUST - why in the world would they assume you wanted the fields in an order other than they are in the database? Please add this feature ASAP... New to Power BI - 30years in the industry. Will need to find another product, large tables are unmanageable.

Ian Bennett's profile image Profile Picture

Jim on 05 Jul 2020 23:13:43

RE: Customize fields list ordering

See Martin's Post before this one. Please navigated to his Cross Post and vote for it as well to elevate this request.

Ian Bennett's profile image Profile Picture

Mark-Allen Perry on 05 Jul 2020 23:11:59

RE: Customize fields list ordering

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.

Ian Bennett's profile image Profile Picture

Martin Thøgersen on 05 Jul 2020 23:07:42

RE: Customize fields list ordering

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.

Ian Bennett's profile image Profile Picture

Martin Thøgersen on 05 Jul 2020 23:07:41

RE: Customize fields list ordering

Cross post https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18355429-use-field-order-as-ordered-in-source-query