In this article, we’ll show how to reorder table columns in a Power BI report.
When a Table Visualisation is created, Fields and Measures will be added to a table in the order they are selected. If many Fields and measures are added, those to the right of the table may appear off the visible page, and not be immediately visible.
Where that's the case, it can be helpful to reorder the columns so that key information is visible to the left of the table, and visible right away when the report is opened.
Watch the video or follow the steps below to see how
Steps to change the order of columns in a table
- Start a new User-created report or open an existing report
- Create a new Table Visualisation or click to select an existing Table Visualisation
- Open the Visualisations panel. The table columns will be listed in the order they were added
- Drag and drop the fields and measures to rearrange them into your preferred order. Fields at the top appear at the left of the table:
- Select 'Save' to keep the changes
Discover more about User-created reports
For a hands-on learning experience, explore our Deep dive courses in The Academy, and watch as Gary builds reports from scratch to meet specific briefs.
If you prefer to start at the beginning, check out Get Started: Reporting and Analytics with Power BI. You'll begin with Power BI’s top five features, then dive deeper into each one with step-by-step guidance.
Need quick answers? Check out our FAQ, Reporting and Analytics with Power BI, packed with 100+ common questions and in-depth resources. You can also join our regular Ask Me Anything: Reporting live events, to ask your question directly to a Power BI expert. Search PWRFAQ in The Academy for real-world use cases, examples, and scenarios with User-created reports.
Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.