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

Chayakiran on 06 Jul 2020 00:08:27

RE: Customize fields list ordering

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.

Ian Bennett's profile image Profile Picture

Fred Stimler on 06 Jul 2020 00:07:34

RE: Customize fields list ordering

Please use the sort order of the source - I can never find my fields

Ian Bennett's profile image Profile Picture

Power BI User on 06 Jul 2020 00:07:27

RE: Customize fields list ordering

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.

Ian Bennett's profile image Profile Picture

Power BI User on 06 Jul 2020 00:06:54

RE: Customize fields list ordering

allow fields to be ordered the same as the source query rather than alphabetical.

Ian Bennett's profile image Profile Picture

AlainD on 06 Jul 2020 00:06:38

RE: Customize fields list ordering

Typically the type of distinctive feature between professional and amateur software. Please implement asap.

Ian Bennett's profile image Profile Picture

Missy Jaroneski on 06 Jul 2020 00:06:29

RE: Customize fields list ordering

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.

Ian Bennett's profile image Profile Picture

Jesse Glidden on 06 Jul 2020 00:06:21

RE: Customize fields list ordering

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.

Ian Bennett's profile image Profile Picture

Tad Borowski on 06 Jul 2020 00:06:11

RE: Customize fields list ordering

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.

Ian Bennett's profile image Profile Picture

bob the builder on 06 Jul 2020 00:06:00

RE: Customize fields list ordering

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.

Ian Bennett's profile image Profile Picture

Adam on 06 Jul 2020 00:05:49

RE: Customize fields list ordering

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.