Reporting - Change the order of columns in a table

*** Please note, this article refers to the All-new Reporting and Analytics. View the FAQ for more details. ***

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

1. Start a new User-created report or open an existing report
2. Create a new Table Visualisation or click to select an existing Table Visualisation
3. Open the Visualisations panel. The table columns will be listed in the order they were added
4. 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:
5. Select 'Save' to keep the changes

Find out more about reporting and analytics with Microsoft Power BI

Join us live for Key techniques for using Power BI fixed reports in The Academy. We'll start with a tour of the Power BI reporting area, then, we’ll open up the Learning Progress report and using real-life examples, we’ll dive into the detail.

If you're using Reporting and Analytics already and have a question, come along to our 'Ask me Anything' events in the Academy to ask questions and share feedback directly with the team.

Join us for our update and roadmap live event to see the latest feature releases and roadmap for the next quarter and share feedback directly with the team. 

Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.