Skip to main content

Power BI

Needs Votes

Customize fields list ordering

Vote (309) 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 (55)
Ian Bennett's profile image Profile Picture

6473792d c27e-4573-b906-eec10096a3f9 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

3cc2b398 0ec0-40cd-a336-c0125bee1660 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

8afe5eb0 a67c-488c-9e95-b1d25a657c8c 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

1c55fd2d 4dc5-4593-bda6-fb9c72bf0500 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.