Forum Discussion
Prevent Table Columns from Auto Sorting in Data View
Hi, I'm building a report based on some survey data, and went through the process of ordering all columns in "Transform Data". But when I came to the main view to build the report, everything wa...
Hi batranikhil,
Tables and columns in Power BI Desktop are by default sorted alphabetically. The custom order that you made in Power Query (or the order that came from the source system for that matter) will not propagate to the datamodel. If you want to enforce a certain order you'll have to rename the columns (for example by adding a prefix) to follow that logic.