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 (76)
RE: Customize fields list ordering
Another basic feature that is not likely to see the light of day.
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!
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.
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
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. :)
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
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.
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
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!
RE: Customize fields list ordering
It is amazing that this was not implemented in the first release of PowerBI Desktop let alone left unaddressed for years. Does anyone want to always be forced to have their fields listed in alphabetical order when designing in PowerBI desktop? (Not talking about sorting in visuals) It makes one wonder if any user testing or feedback was considered in the initial design of the interface. Does anyone know if there is a reason why this would be difficult to fix?