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

c12104c6 553a-44e2-b420-b1043f6fd3e4 on 06 Jul 2020 00:03:27

RE: Customize fields list ordering

Let's go Microsoft.

Ian Bennett's profile image Profile Picture

b4ae9975 89e5-4e0c-840c-8510aea1ab0d 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

9ea8e222 e66e-4eec-8677-0da46f6854bb 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

f8c3999e 59b0-42ec-901c-c14e522a679f on 05 Jul 2020 23:59:48

RE: Customize fields list ordering

Please add this. Absolutely essential!

Ian Bennett's profile image Profile Picture

59bdc489 dcc8-4db8-90e4-b3c1fd12b11d 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

f0aa65ea 51b6-4e8e-a1f8-9a2a51ee8134 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

ed6d8bda c0f6-4382-a799-b4b2d14b690b 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

e443a452 bc5e-4f10-b78d-730a45586571 on 05 Jul 2020 23:56:48

RE: Customize fields list ordering

I also fully agree on that.

Ian Bennett's profile image Profile Picture

64c5f7c1 96a2-4935-bc74-292f491a92f0 on 05 Jul 2020 23:51:11

RE: Customize fields list ordering

Yes, please update this feature.

Ian Bennett's profile image Profile Picture

0074d8fc eba5-4dcc-96de-4d3c3109aff7 on 05 Jul 2020 23:50:03

RE: Customize fields list ordering

This would be really useful and consistent with Excel Pivot Tables