Forum Discussion
Field List Order (Columns)
How do I get the sort this based on my source data?
amitchandak lbendlin parry2k Samarth_18 johnt75 TheoC Greg_Deckler bcdobbs jdbuchanan71 mahoneypat
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
3 Replies
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.
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
