How to Hide Pages in Power BI
Hiding a page in your Power BI report is a simple trick that unlocks powerful functionality and creates a cleaner experience for your users. Whether you're building detailed drill-through pages or custom tooltips, hiding pages is a fundamental skill for creating professional, intuitive reports. This tutorial will walk you through exactly why and how to hide pages in both Power BI Desktop and Service.
Why Would You Hide a Page in Power BI?
Before jumping into the "how," it's helpful to understand the "why." Hiding a report page isn't about concealing data maliciously, it's a design choice that enhances usability. You can improve navigation and guide users to the most important insights without overwhelming them.
Here are the most common reasons to hide a Power BI page:
- For Drill-Through Reports: Drill-through pages are a fantastic feature that allows users to navigate to a different, more detailed page by right-clicking a specific data point. For example, a user could right-click on "Q4" in a yearly sales chart to see a detailed breakdown of that quarter's performance. The "Q4 Details" page shouldn't be a primary navigation tab, it should only be accessible through this action. Hiding it makes the user flow logical.
- For Custom Tooltips: Power BI lets you design a small, separate report page to act as a custom tooltip. When a user hovers over a visual, this custom-designed page appears with extra context and visuals. This page is purely functional and would just clutter the main navigation if it were visible.
- To Hold Bookmarks or Information: Sometimes, you might create a page specifically to contain buttons or navigation elements linked to bookmarks. This central navigation page might not contain initial insights and is best kept hidden until accessed via a button.
- For "Work-in-Progress" or Reference Pages: As a report developer, you often have scratchpad pages where you test visuals, write DAX measures, or store technical information. These pages are essential for you but would only confuse end-users. Hiding them keeps your final published report clean and focused.
In short, hiding pages allows you to add layers of detail and interactivity to your report without complicating the primary user interface.
Step-by-Step Guide: How to Hide a Power BI Page
The process of hiding a page is straightforward and is done within Power BI Desktop before you publish your report online. Once hidden in the desktop file, the page will automatically be hidden when published to the Power BI Service.
Follow these simple steps:
Step 1: Open Your Report in Power BI Desktop
Start by launching Power BI Desktop and opening the report file (.pbix) that contains the page you want to hide.
Step 2: Locate the Page Tabs
At the bottom of your screen, you'll see a series of tabs, one for each page in your report. This is your main navigation panel.
Step 3: Right-Click the Page You Want to Hide
Identify the tab for the page you wish to hide. Right-click on its name to bring up the context menu, which provides several page-level options.
Step 4: Select "Hide page"
From the menu, simply click on Hide page. You'll immediately see two visual cues:
- The page name on the tab will be greyed out.
- A small "hidden" icon (an eye with a slash through it) will appear next to the page name.
That's it! As the report author in Power BI Desktop, you can still see and edit the page. However, once you publish the report, this page will be completely invisible to your end-users in their navigation pane.
A Practical Example: Hiding a Drill-Through Page
Let's walk through the most common use case to see this in action. Imagine we have a main "Sales Summary" page showing total sales by country. We want to allow users to right-click a country and "drill through" to a hidden "Country Details" page.
1. Create Your Main and Detail Pages
First, create your two pages:
- Sales Summary: This page has a map visual or a bar chart showing sales for each country.
- Country Details: This page contains more granular visuals, like sales by city or product category. This is the page we will eventually hide.
2. Configure the Drill-Through Field
On your Country Details page, you need to tell Power BI which data field will trigger the drill-through.
- Select the Country Details page.
- With no visuals selected, look at the Visualizations pane.
- Find the "Drill through" section at the bottom.
- Drag your Country field from your data table into the box that says "Add drill-through fields here." A "back" button will automatically be added to your report canvas.
3. Hide the Detail Page
Now, follow the steps from the previous section. Right-click the Country Details page tab at the bottom and select Hide page. The tab will turn grey.
4. Test and Publish
Go back to your Sales Summary page. In Power BI Desktop, right-click one of the bars or country sections in your main visual. You should now see a "Drill through" option that lets you navigate to "Country Details."
When you publish this report to the Power BI Service, users will not see "Country Details" in the page list on the left. But when they right-click a country on the main page, the drill-through will work perfectly, taking them to the hidden page for a deeper analysis.
How to Unhide a Page in Power BI
If you need to make a hidden page visible again, the process is just as easy.
- Open the report in Power BI Desktop.
- Find the greyed-out tab of the hidden page.
- Right-click the tab.
- In the context menu, click Hide page again. The checkmark next to the option will disappear.
The page name will return to its normal color, the hidden icon will vanish, and the page will once again be visible to end-users after you republish the report.
Best Practices and Pro-Tips
To keep your reports organized and efficient, follow these best practices:
- Clear Naming Conventions: Adopt a clear naming system for your hidden pages. Prefixes like "DT - Country Details" for a drill-through or "TT - Product Info" for a tooltip help you quickly identify the page's purpose within Power BI Desktop.
- Don't Forget About Performance: Hidden pages, just like visible ones, contribute to your report's overall size and refresh time. Keep them optimized by removing unnecessary visuals or data.
- Organize Your Tabs: Keep all your hidden functional pages (tooltips, drill-throughs) grouped together, perhaps at the end of your page tabs. This makes report management easier for you and other developers. Just drag and drop the tabs to reorder them.
- Always Test After Publishing: Before sharing the report widely, open it in the Power BI Service and test it from the perspective of an end-user. Ensure all navigation buttons, tooltips, and drill-throughs work as expected.
Final Thoughts
Hiding report pages in Power BI is a core technique for creating sophisticated, tiered reports that guide users to insights without overwhelming them. By using hidden pages for drill-throughs, custom tooltips, and developer notes, you can build cleaner, more professional dashboards that are easier for your audience to navigate.
While mastering tools like Power BI is incredibly rewarding for deep data analysis, the process can be slow and technical if all you need are quick answers from your business data. At Graphed, we created a way to get you from data sets to dashboards instantly. You can connect sources like Google Analytics, Shopify, and Salesforce in seconds and use plain English to ask questions and build the exact reports you need in real-time, removing the technical barrier and getting you straight to the insights.
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.