How to Merge Two Pages in Power BI

While Power BI doesn't have a simple "merge pages" button, you can consolidate reports to create a richer, more context-aware dashboard. The goal is to combine visuals from different pages onto one, creating a unified view that simplifies navigation and tells a more cohesive data story. This article will walk you through the methods to get it done, from a simple copy-paste to more advanced techniques using bookmarks.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Would You Want to Merge Pages in Power BI?

Before jumping into the "how," let's quickly cover the "why." Consolidating your report pages offers some major benefits for anyone who will be using your dashboard.

• Improved User Experience: Merging related information reduces the need for users to click back and forth between tabs. Instead of having a "Sales Summary" page and a separate "Sales by Region" page, you can combine them for a seamless analytical flow.
• Better Data Storytelling: A single, well-organized page can guide the user through a narrative more effectively. You can start with high-level Key Performance Indicators (KPIs) at the top and progress to more granular charts below, all within a single view.
• Simplified Navigation: Too many tabs can be overwhelming. Combining pages cleans up your report's navigation, making it easier for users to find what they need without getting lost.

Method 1: The Simple Copy and Paste

The most straightforward way to merge visuals from two pages is to copy them from one and paste them onto another. It’s quick, easy, and preserves most of your formatting and settings.

Step-by-Step Instructions:

1. Open Your Power BI Report: Start by navigating to the page that contains the visual (or visuals) you want to move. This will be your source page.
2. Select a Visual: Click on the chart, table, or KPI card you want to copy. A border will appear around it, confirming your selection.
3. Copy the Visual: You can either right-click the selected visual and choose Copy > Copy visual, or simply press the common keyboard shortcut Ctrl + C.
4. Select Multiple Visuals (Optional): If you want to move several items at once, hold down the Ctrl key while clicking each visual. This allows you to select them all. Once selected, press Ctrl + C to copy the entire group.
5. Navigate to the Destination Page: Go to the report page where you want to add the visuals. This is your destination page. If you are creating a brand new summary page, you can create it by clicking the ‘+’ icon in the page navigation bar.
6. Paste the Visual: Click on an empty area of the report canvas and press Ctrl + V to paste. The visual will appear, retaining its data connections, filters, and formatting from the original page.
7. Reposition and Resize: Drag the visual to its new position on the page. Use the handles on its border to resize it as needed to fit your new layout.

This method is perfect for consolidating just a few visuals or creating a high-level summary dashboard from key charts scattered across your report. However, after copying everything over, the real work of ensuring it functions as a single, interactive page begins.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Making Sure Everything Works Together

Simply pasting visuals onto a page is just the first step. To create a truly cohesive dashboard, you need to ensure all the components interact with each other correctly. If you paste a slicer from another page, you expect it to filter all the relevant charts, not just the one it came with.

Check and Edit Visual Interactions

When you filter data using a slicer or by clicking on a data point in a chart, Power BI needs to know which other visuals on the page should react. You have full control over these interactions.

1. Select a "Controlling" Visual: Click on the slicer or chart that you want to use as a filter for other visuals on the page.
2. Open Edit Interactions: With the visual selected, go to the Format tab in the Power BI ribbon at the top of the screen. Click on Edit interactions.
3. Define the Interaction: After clicking "Edit interactions," small icons will appear in the top-right corner of all other visuals on the page. You have three choices for each visual:
4. Repeat for All Key Visuals: Go through your primary slicers and charts, setting the interactions for each to ensure your new, consolidated page behaves exactly as you intend. The goal is to make the dashboard intuitive.

How to Organize Your New Combined Page

A merged page can quickly become cluttered. Thoughtful organization is key to making your dashboard readable and useful. Power BI's formatting tools are your best friend here.

Align and Distribute Visuals for a Clean Look

Jagged, misaligned charts make a dashboard look unprofessional and difficult to interpret. Use the alignment tools to tidy things up.

• Multi-select the visuals you want to align (hold Ctrl and click each one).
• Navigate to the Format tab on the ribbon.
• Click the Align dropdown. Here you can find powerful options like:

Taking a few moments to align your KPI cards and charts creates a clean, grid-like structure that is much easier for the brain to process.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Group Related Objects

If you have a chart and a few related KPI cards that always move together, you should group them. Select the visuals you want to group, right-click, and select Group > Group (or use the option on the Format tab). Now, this collection of visuals acts as a single object, which you can move and resize together, saving you a tremendous amount of time on readjustments.

Advanced Merging: Toggling Views with Bookmarks

What if you want to merge two very dense pages without cramming them into one long, scrollable report? This is where bookmarks come in. You can use bookmarks and buttons to create "views" within a single page, effectively giving you two separate reports in the space of one.

Let's imagine you want to merge a "Sales Overview" page with a "Product Detail" page. Here’s how you can do it with bookmarks:

1. Lay Out All Visuals on One Page

First, use the copy-paste method to move all visuals from both the "Sales Overview" and "Product Detail" pages onto a single destination page. Don't worry about perfect placement yet, just get them all on the canvas.

2. Use the Selection Pane to Organize

Visual organization is critical for this technique.

• Go to the View tab and enable the Selection pane.
• This pane lists every single element on your report page. Double-click on each visual's name and give it a descriptive title (e.g., "Sales Overview KPI" or "Product Details Table"). Grouping visuals here can also help organize the list.

3. Create Your First Bookmark (Overview)

• In the Selection pane, click the "eye" icon to hide all the Product Detail visuals. Your page should now only display the "Sales Overview" charts.
• Go to the View tab and open the Bookmarks pane.
• Click Add. A new bookmark will appear. Rename it to "Sales Overview".
• Very important: Click the three dots (...) next to the bookmark name and uncheck Data. This ensures that when you toggle bookmarks, it doesn't reset your data filters.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

4. Create Your Second Bookmark (Product)

• Now, reverse the visibility. In the Selection pane, show all the Product Detail visuals and hide all the Sales Overview visuals.
• Add another bookmark and rename it to "Product Detail".
• Again, click the three dots and make sure the Data option is unchecked.

5. Add Buttons to Complete the Experience

• Now, let's add navigation so users can switch between these views.
• Go to the Insert tab, click Buttons, and select a blank button. Add two distinct buttons to your page. Label one "Sales Overview" and the other "Product Detail" using the Text property in the Format pane.
• Select the "Sales Overview" button. In the Format pane, turn on the Action toggle.
• Do the same for the "Product Detail" button, linking its Action to your "Product Detail" bookmark.

You've now successfully merged two pages into one dynamic report! Users can click the buttons to swap between two completely different layouts without ever leaving the page, creating a clean and highly professional user experience.

Final Thoughts

While Power BI doesn't offer a one-click merge function, combining your report pages is entirely possible - and often recommended. By methodically copying visuals, configuring their interactions, and applying smart visual design, you can consolidate scattered information into a single, cohesive dashboard that tells a compelling data story.

Mastering tools like Power BI often involves a significant learning curve, from wrangling data to arranging layouts. Manually building and refining dashboards like this can be time-consuming. We built Graphed because we believe getting insights from your data shouldn't be so complex. By simply connecting your data sources and describing what you want to see - like “create a dashboard showing sales broken down by region and product” - you can instantly generate interactive and fully connected dashboards without the hours of manual-clicking and adjusting in traditional BI tools.