Skip to main content

Power BI

Needs Votes

Customize fields list ordering

Vote (566) 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

vvanasperen on 05 Jul 2020 23:06:58

RE: Customize fields list ordering

Would really like this to be supported.

Ian Bennett's profile image Profile Picture

Jonnie Martin on 05 Jul 2020 23:06:17

RE: Customize fields list ordering

Great Idea, and possibly to group fields together as well?

Ian Bennett's profile image Profile Picture

Shelley on 05 Jul 2020 22:55:52

RE: Customize fields list ordering

When looking at the tables in the Relationships window - and to make new relationships - it would really help to show the fields in alphabetical order. It feels like I'm always going on a scavenger hunt when I'm trying to find a field because I have to scroll thru the entire list looking for it. This can be challenging and time consuming, especially with large tables. Thanks!

Ian Bennett's profile image Profile Picture

Gorham on 05 Jul 2020 22:53:13

RE: Customize fields list ordering

Currently if you set the "Default Field Set" field order in an SSAS Tabular model, it is not utilized by Power BI in the Fields pane. It still only sorts alphabetically.

Ian Bennett's profile image Profile Picture

Power BI User on 05 Jul 2020 22:49:36

RE: Customize fields list ordering

can you order variables in fields section as imported from Excel

Ian Bennett's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:47:00

RE: Customize fields list ordering

Found a related idea: "Display field names in database, not alpha, order"

Ian Bennett's profile image Profile Picture

Bruce on 05 Jul 2020 22:27:59

RE: Customize fields list ordering

The task pane displays database fields in alphabetical order. Please allow the field list to be displayed in original, or database defined order.