If you need to fix hidden panes in Power BI or Power Query, you’re not alone. Missing items like the Formula Bar, Applied Steps pane, or Filters panel can slow down your workflow. The good news? These features aren’t deleted they’re simply hidden, and you can restore them in just a few clicks.
Maybe your Formula Bar disappeared.
Maybe the Applied Steps pane is gone.
Or perhaps your Filters, Data, or Visualization panes vanished in Power BI Desktop.
The good news? You didn’t delete them they’re just hidden.
In this guide, you’ll learn exactly how to restore hidden panes in Power Query and Power BI Desktop using simple, built-in options.
Why Do Panes Go Missing in Power BI?
Most missing panes happen because:
- They were accidentally turned off in the View tab
- The layout was modified
- The modern pane switcher was customized
- A chevron (expand/collapse arrow) was clicked
Fortunately, everything can be restored in seconds.
Fixing Hidden Panes in Power Query Editor
Let’s start inside Power Query Editor.
1. Restore the Queries Pane (Using the Chevron)
If your Queries pane is missing:
- Look for the small chevron (arrow) on the left side
- Click it to expand the pane
- Your list of queries will instantly reappear
This is the quickest fix and often the most overlooked.
2. Bring Back the Applied Steps Pane
Missing your Applied Steps?
Here’s how to restore it:
- Go to the View tab
- Under the Layout section
- Click Query Settings
When you select Query Settings, the Applied Steps pane reappears on the right side.
Many users accidentally close it and assume it’s deleted but it’s simply hidden.
3. Turn the Formula Bar Back On
The Formula Bar displays your M code, which is essential when working with transformations.
If it’s missing:
- Go to the View tab
- Check the Formula Bar option
Once enabled, your M expressions will appear again.
This is especially important for advanced Power Query users who write or modify M code manually.
4. Missing Parameter Options? Enable Parameters
If you’re creating a Conditional Column and don’t see the option to use parameters:
- Go to the View tab
- Enable Parameters
Once allowed, your parameters will be available when building conditional logic or dynamic transformations.
Fixing Hidden Panes in Power BI Desktop
Now let’s switch to the Power BI Desktop experience.
Power BI uses a modern pane switcher that allows you to customize what appears on the right-hand side.
Understanding the Modern Pane Switcher
You may also need to fix hidden panes in Power BI Desktop’s modern interface.
Power BI uses a customizable pane system that includes:
-
Filters
-
Data
-
Build (Visualizations)
-
Format
-
Bookmarks
-
Selection
-
Performance Analyzer
-
Sync Slicers
When any of these disappear, you can fix hidden panes using the steps below.
1. Use the Pane Manager to Restore Hidden Panes
The Pane Manager is your main control center.
To fix hidden panes:
-
Go to the View tab
-
Select Pane Manager
-
Toggle the panes you want visible
You can turn everything off and re-enable only what you need.
2. Too Many Panes? Resize or Minimize Them
Sometimes you don’t need to fix hidden panes you need to manage too many open ones.
You can:
-
Use the chevron to minimize
-
Use the ellipses (…) to close
-
Resize panels manually
This keeps your report canvas clean and organized.
Pro Tip: The View Tab Is Your Best Friend
Whenever something is missing in:
- Power Query Editor
- Power BI Desktop
- Microsoft Fabric
Always check the View tab first.
Nearly every hidden pane issue can be fixed there.
Common Hidden Pane Fix Checklist
If something is missing, check:
- ✅ View → Query Settings (Applied Steps)
- ✅ View → Formula Bar
- ✅ View → Parameters
- ✅ Chevron expanders
- ✅ View → Pane Manager (Power BI Desktop)
This quick checklist will solve 95% of layout issues.
Improve Your Power BI Skills
If you want to go deeper into Power Query, data modeling, DAX, and dashboard design, professional training can accelerate your growth.
