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

Eva Ramón on 10 Jun 2022 09:18:41

RE: Customize fields list ordering

custom order of values, for example in bar charts, to be able to customize the order and not just AZ or ZA

Ian Bennett's profile image Profile Picture

Jeremy Van Gurp on 12 May 2022 20:57:25

RE: Customize fields list ordering

Another basic feature that is not likely to see the light of day.

Ian Bennett's profile image Profile Picture

David Baath on 05 May 2022 10:47:53

RE: Customize fields list ordering

As everyone else have already mentioned, this feels like a very standard option to have. Would make our lives easier. Please add it!

Ian Bennett's profile image Profile Picture

CLEARIFY . on 05 Mar 2022 04:58:49

RE: Customize fields list ordering

Alpha only helps if you know what you are looking for. One person may say chair, and one person thinks blue sofa, and the other thinks bar stool. Sometimes the logical order is not alphabetical.

Ian Bennett's profile image Profile Picture

hi hi on 13 Jan 2022 08:40:21

RE: Customize fields list ordering

Why PBI is so stupid on this. Version 2.97.921.0 64-bit (September 2021) dont have any sort field same as column of table

Ian Bennett's profile image Profile Picture

Brett Baker on 23 Dec 2021 01:55:21

RE: Customize fields list ordering

This is an important requirement. It makes determining the primary keys intuitive when working with relational databases as your source data. As we all know the left most field(s) are where they reside. :)

Ian Bennett's profile image Profile Picture

Jonathan Conzatti on 11 May 2021 21:00:59

RE: Customize fields list ordering

This isnt right had to code something to fix a problem with pbi in excel but....
I tried to find a way to fix my ordering columns but fail. so i made a workaround to fix it.
Im posting here to help others while the Microsoft dont fix this problem.

'Create in 11/05/2021
'Create by Jonathan Giulian Conzatti
'Input "Column1", "Column2", "Column3", "ColumnN"
'You can get the columns name selecting this in power query and deleting other columns for example
'Output {"Column1", "1 Column1"},{"Column2", "2 Column2"},{"Column3", "3 Column3"},{"ColumnN", "4 ColumnN"}
'Than you can edit your rename column with this set os renames
Function NumberColunmsPBI(base As String) As String
Dim newSet As String
Dim i As Long

newSet = ""
i = 1
basesplited = Split(base, ",")

For Each oldSet In basesplited
newSet = newSet & IIf(newSet = "", "", ", ") & "{" & oldSet & "," & Chr(34) & i & " " & Replace(oldSet, Chr(34), "") & Chr(34) & "}"
i = i + 1
Next oldSet

NumberColunmsPBI = newSet
End Function

Sub test()
Cells(2, 1).Value = NumberColunmsPBI(Cells(1, 1).Value)
End Sub

Ian Bennett's profile image Profile Picture

Josh Mattingly on 06 May 2021 13:09:26

RE: Customize fields list ordering

Another example of an obvious feature that should have been included in PBI from the start. Where competitors focus on doing a few things well, Power BI does a bunch of things just okay. The fact that sorting fields in data model order was requested over four years ago with absolutely no movement is ridiculous.

Ian Bennett's profile image Profile Picture

Elsie Baker on 07 Apr 2021 11:58:16

RE: Customize fields list ordering

Yes please implement this - this is my first time using Power BI and its the first issue I can see

Ian Bennett's profile image Profile Picture

Vietanh Nguyen on 01 Mar 2021 03:55:50

RE: Customize fields list ordering

Why this not done yet? I have searched many and found that there is no way to do this. When you have a data table with lots of columns that already ordered logically. But when input in PBI, Fields automatically organises them in alphabet? Terrible!