Field List Order (Columns)

[rdumbre]

How do I get the sort this based on my source data?

@amitchandak @lbendlin @parry2k @Samarth_18 @johnt75 @TheoC @Greg_Deckler @bcdobbs @jdbuchanan71 @mahoneypat 

[TheoC]

@rdumbre the field list is sorted alphabetically.  If you want it changed, you would need to rename the fields in order of your source data.

[mahoneypat · Accepted solution]

Although I don't recommend it (and didn't confirm it), but you could accomplish this by dynamically prefixing the column names with a variable number of zero-width spaces based on their position in Table.ColumnNames. However, that would complicate writing measures (e.g., manually typing in column names, but you could pick them from the list correctly).

Pat

[amrans]

Based on my observation you are asking for custom sorting in Power BI Desktop UI which seems not possible. Custom sorting can be implmented on visuals only when you are developing report.