How to Hide and Show Pages in Power BI

Power BI allows report designers to create multiple pages within a report to organize data and present insights effectively. However, there are situations where certain pages should remain hidden from end users while still being available for drill-through reports, testing, or administrative purposes.

By hiding and showing pages strategically, you can simplify report navigation, improve user experience, and maintain cleaner report layouts.

Why Hide Pages in Power BI?

Create cleaner dashboards
Hide intermediate report pages
Support drill-through functionality
Reduce user confusion
Control report navigation
Organize report development pages

Business Scenario

Suppose your sales dashboard contains multiple pages. Users should only see Summary and Sales Analysis pages, while internal calculation or drill-through pages remain hidden.

How to Hide a Page

Open Power BI Desktop.
Select the report page tab.
Right-click the page.
Choose Hide Page.

Page Tab

↓

Right Click

↓

Hide Page

How to Show a Hidden Page

Locate the hidden page tab.
Right-click the page.
Select Show Page.

Hidden Page

↓

Right Click

↓

Show Page

Hidden Page Indicator

Power BI displays hidden pages with a faded page tab, indicating that the page is hidden from normal report navigation.

Common Use Cases

Drill-through pages
Administrative reports
Calculation pages
Development and testing pages
Supporting analytics pages
Navigation control

Important: Hidden pages are not deleted. They remain part of the report and can still be accessed through drill-through actions or by report designers.

Benefits

Cleaner user interface
Better report organization
Improved user experience
Enhanced navigation control
Support for advanced reporting scenarios

Best Practices

Hide only supporting pages.
Use meaningful page names.
Document hidden page purposes.
Test drill-through functionality.
Maintain a simple report structure.

Key Takeaways

Power BI allows pages to be hidden without deleting them.
Hidden pages improve report organization.
Useful for drill-through and administrative pages.
Enhances user experience and navigation.
Can be shown again at any time.