How to Move Pages in Power BI
Rearranging the pages in your Power BI report is one of an analyst's most fundamental and important tasks. While the technical process is simple, the strategic order of your pages can be the difference between a report that clarifies and one that confuses. This article shows you how to move pages in Power BI Desktop and the Power BI Service and shares best practices for organizing your report for a helpful user experience.
Why Reordering Your Report Pages Matters
Before jumping into the "how," let's quickly cover the "why." The order of your pages isn't just a matter of personal preference, it directly impacts how your audience understands the data you're presenting. A well-organized report tells a story.
- Logical Flow: Your report should guide the user on a journey, typically from a high-level summary down to the granular details. Placing an executive dashboard as the first page gives stakeholders an immediate overview, and subsequent pages can provide deeper dives into specific areas like marketing, sales, or operations.
- Improved User Experience (UX): An intuitive page layout makes the report easier to navigate. When users can anticipate where to find information, they are more likely to engage with the report, trust its findings, and use it to make decisions. Cluttered or randomly ordered pages create frustration and discourage use.
- Data Storytelling: Effective data analysts are storytellers. The sequence of your visualizations and pages is your narrative structure. You might structure your report to show a problem on page one, explore the causes on pages two and three, and propose a solution based on the data on page four.
How to Move Pages in Power BI Desktop (Drag and Drop)
The simplest method for reordering pages is using the drag-and-drop feature in Power BI Desktop. The interface for managing pages is located in the tabs at the bottom of your report canvas.
Follow these simple steps:
- Open Your Report: Launch Power BI Desktop and open the report file (.pbix) you wish to edit.
- Identify the Page Tabs: At the bottom of the main report window, you'll see a series of tabs, each representing a page in your report.
- Click and Hold: Left-click on the tab of the page you want to move and hold the mouse button down.
- Drag to the New Position: While still holding the mouse button, drag the page tab horizontally along the page navigation bar. A small black vertical indicator line will appear, showing you where the page will be placed.
- Release to Place: Once you've moved the page to your desired spot, release the mouse button. The page will instantly snap into its new position, and the order will be saved automatically with your report.
That's it. It's a very straightforward process that takes only a few seconds. You can repeat this for any page to get your report perfectly organized.
Moving Pages in the Power BI Service
You don't always need to go back to the Power BI Desktop file to adjust page order. If you have the appropriate permissions, you can also rearrange pages directly within the Power BI Service (the web-based version).
Permissions You'll Need
To edit a report in the Power BI service, you need to be a member of the workspace with a role that allows editing, such as Admin, Member, or Contributor. If you only have Viewer access, you will not have the ability to make changes.
Step-by-Step Instructions
- Navigate to Your Report: Log in to app.powerbi.com and navigate to the Workspace that contains your report. Click to open the report.
- Enter Edit Mode: At the top of the report, click the "Edit" button in the action bar. This will switch the view from reading mode to an editing mode that looks very similar to Power BI Desktop.
- Locate the Pages Pane: In Edit mode, the report pages are usually displayed in a vertical list called the "Pages" pane on the right-hand side of the screen. If you don't see this pane, click on the View tab above the filters pane and open it that way. Some reports may have pages located at the bottom left of your computer screen similar to the Power BI Desktop app.
- Drag and Drop: Just like Desktop, click and hold the name of the page you want to move. Drag it up or down in the list to its new location. A horizontal line will indicate its new placement. Then, release the mouse button once it's in the correct order.
- Save Your Changes: After reorganizing your pages, remember to click the "Save" button in the top left toolbar so your new layout is saved for all users. If you navigate away without saving, your changes will be lost.
Hiding and Unhiding Pages
Sometimes, moving a page isn't the right solution. You might have pages that contain detailed data for drill-through actions, source specific visuals for custom tooltips, or are simply a work-in-progress. These pages are necessary for the report's functionality but shouldn't be directly visible in the main navigation because they interrupt the viewing and user experience.
In these cases, you can hide the page.
How to Hide a Page
Whether in Power BI Desktop or the Power BI Service (in Edit mode), the process is the same:
- Right-click on the page tab you want to hide.
- From the context menu, select "Hide Page."
The page tab will now have a small "hidden" icon (an eye with a slash through it) to indicate its status. The hidden page is no longer visible to end-users who are simply viewing the report in the service, but you can still see it while editing in the Power BI Desktop or Service.
Most importantly, hidden pages are still fully functional. You can still set them as the destination for drill-through actions from another page, use a button linked to navigation, or pull visuals from them for tooltips.
Best Practices for Structuring Your Power BI Report
Knowing how to move pages is the first step. Structuring them thoughtfully will elevate your report to be a much more valuable company asset.
1. Start with an Executive Summary
Your first page should always be a high-level overview. This landing page must include the most critical Key Performance Indicators (KPIs) and topline metrics. Stakeholders and executives often only need a 30-second glance to understand business health. This page gives them that, with the option to explore deeper if they choose.
2. Group Related Content Together
Arrange your pages into logical sections. If your report covers both sales and marketing, keep all the sales-related pages (e.g., "Sales Performance," "Pipeline Analysis," "Team Leaderboard") followed by all the marketing pages (e.g., "Campaign ROI," "Website Analytics," "Lead Sources"). This thematic grouping makes navigation intuitive and predictable.
3. Use an Appendix or Definitions Page
Technical terms and complex metrics can confuse users. Consider creating a final page titled "Definitions," "Data Dictionary," or "Appendix." You can hide the page and then link to it on your introduction or landing pages to avoid clutter in your tab bar experience. On each visual with complex calculation, you can set a tooltip to reference the definitions page, as an example - "For information visit the 'Data Dictionary' tab."
4. Create a "Table of Contents" Page
For large reports with many pages, the introduction or first page of the report can serve double duty as a table of contents to each page. This method not only acts as page routing for your audience but gives all team members an immediate understanding of all business aspects being measured and analyzed inside of the dataset. And don't stop there - incorporate interactive buttons/links on your ToC page to make route selection as seamless as a click through a modern-day website or app.
5. Don't Overwhelm with Too Many Pages
More isn't always better. A report with 25 different tabs is intimidating and hard to maintain. A well-designed report with only five or six focused pages with high filtering capabilities and interactive drilldowns is often much more powerful. Strive to combine related visuals onto a single page rather than creating a new page for every little chart.
Final Thoughts
Rearranging pages is a core skill set within Power BI, turning a complex data set into a clear story. Moving and hiding pages with a direct goal for audience flow and usability of the dashboard can not only impress its daily users but lead to faster data-driven decisions.
While mastering tools like Power BI is valuable, the ultimate goal is to get answers from your data faster while limiting manual work along the way. Instead of piecing together reports and dashboards yourself from tools like Google Analytics, Shopify, and Salesforce - we've created a more straightforward AI-first approach to analytics. We allow anyone to simply ask questions in plain English to immediately get back live-updating charts and dashboards in return. With Graphed , you spend your time acting on insights, not building and maintaining reports from them.
Related Articles
How to Enable Data Analysis in Excel
Enable Excel's hidden data analysis tools with our step-by-step guide. Uncover trends, make forecasts, and turn raw numbers into actionable insights today!
What SEO Tools Work with Google Analytics?
Discover which SEO tools integrate seamlessly with Google Analytics to provide a comprehensive view of your site's performance. Optimize your SEO strategy now!
Looker Studio vs Metabase: Which BI Tool Actually Fits Your Team?
Looker Studio and Metabase both help you turn raw data into dashboards, but they take completely different approaches. This guide breaks down where each tool fits, what they are good at, and which one matches your actual workflow.