Forum Discussion
Column Order in PBI
How can I keep the column order from my data source? PBI seems to change to alpha order. Ex. - Columns labeled and ordered: 'Actual, Previous, Budget, Forecast', get reordered in PBI as 'Actual, Budg...
If you are talking about the table\column order in the Field List, then curently you cannot change it. We do have a feature in the backlog to allow Alpha. Natural and Customer order.
If you want to sort categories in the visual using specific order, then you can use the Sort By feature in PBI Desktop. It allows you sorting one column in the model by another. You will need to create adiitional column in the table that contains the sort order as a numeric.
Alex.
AlexGorev: Could you point me to the link in the backlog? Or is this something we don't have to vote for anymore? ;-)