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

Kasun on 05 Jul 2020 23:51:11

RE: Customize fields list ordering

Yes, please update this feature.

Ian Bennett's profile image Profile Picture

Wyn Hopkins on 05 Jul 2020 23:50:03

RE: Customize fields list ordering

This would be really useful and consistent with Excel Pivot Tables

Ian Bennett's profile image Profile Picture

Marcin on 05 Jul 2020 23:49:13

RE: Customize fields list ordering

OMG I'm missing this sooo much!

Ian Bennett's profile image Profile Picture

Power BI User on 05 Jul 2020 23:47:45

RE: Customize fields list ordering

Please let this happen soon. :-)

Ian Bennett's profile image Profile Picture

Chris Nunn on 05 Jul 2020 23:44:52

RE: Customize fields list ordering

Please add this soon. It is so frustrating trying to find a field in alphabetical order when we are so used to our data being ordered in a different way.

Ian Bennett's profile image Profile Picture

SudDevSupport on 05 Jul 2020 23:42:32

RE: Customize fields list ordering

I would like to customize the list of fields in view mode of the records in a report and save it.

Ian Bennett's profile image Profile Picture

Sam Marshall on 05 Jul 2020 23:41:29

RE: Customize fields list ordering

Agreed! I would be much obliged if you would kindly fix this. About a week into using Power BI and this is my biggest gripe by far. I am constantly playing hunt the field, whereas if it was in the original order I would just know - I would already be moving my mouse pointer to roughly the right part of the list before even thinking about it. Particularly problematic with calculated columns on the end of data set with a "flow" from one to the next in a logical manner. To my mind isLate comes after daysToTarget and I'm don't think I will ever come to see alphabetical order as an improvement. This is just one example from my work today which I hope explains the point.

Ian Bennett's profile image Profile Picture

Chris Burgess on 05 Jul 2020 23:38:57

RE: Customize fields list ordering

Usually in a pivot table field view you may choose to sort the fields alphabetically or data source order. However, if you also happen to hide any field from client tools, you may no longer sort in data source order, alphabetically only.

Ian Bennett's profile image Profile Picture

Gavin Broughton on 05 Jul 2020 23:32:51

RE: Customize fields list ordering

Please consider this, it would be a very useful "cosmetic" change. Oddly hard to find the field you're looking for when you're so used to seeing it in table column order. Address data in particular is a pain to add from an alphabetical list.

Ian Bennett's profile image Profile Picture

Janis on 05 Jul 2020 23:32:11

RE: Customize fields list ordering

Yes, please, go for it.