Customize fields list ordering

[beneuto1]

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.

[jonathan_conzat]

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

[Brett_Baker]

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. 🙂

[dothanh_hao]

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

[admin49]

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.

[David_Baath]

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

[jvangurp1]

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

[eramon]

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

[elarson1]

How is this not a standard feature? I've been a cognos developer for 15 years and this is always been standard and eases report writers jobs by not having to hunt for things. Blows my mind that I have to do ham-fisted things like add prefixes in order to get a sort order that logically makes sense. What is this 1990? This request is from 2017 as well.

[lfoley]

I've just wasted two days cleaning up a massive Excel file and just now discovered that Power BI sorts columns in alphabetical order in the Fields Pane. The data I was trying to visualize are survey responses, so the column order in the original file is crucial. Well, at least I was able to get a definitive proof-of-concept result: I can't use Power BI to create dashboards from survey data.

[B_Johnson]

5 years and this has not yet made it to the top of changes? Please ask your developer friends if they agree this would be really useful - and if so ask them to vote!