How to Go Back in Power BI

Made a change in Power BI that you instantly regret? It happens to everyone. Whether you accidentally deleted the wrong visual, applied a funky filter in the Power Query Editor, or just want to revert to an older version of your report, knowing how to "go back" is an essential skill. This guide will walk you through the various ways to undo actions and navigate your reports with confidence.

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

The Simplest "Go Back": Using Undo and Redo

The most common way to reverse a recent action is the universal keyboard shortcut for "undo." This should always be your first instinct when you make a small mistake within Power BI Desktop.

Using Keyboard Shortcuts

Just like in Word or Excel, the classic shortcuts work here:

• Undo: Ctrl + Z
• Redo: Ctrl + Y

If you resized a visual by mistake, changed a color, or added a text box you didn't mean to, just hit Ctrl + Z to instantly revert the action. If you go back too far, Ctrl + Y will redo the action you just undid.

Using the On-Screen Buttons

Power BI Desktop also includes dedicated Undo and Redo buttons in the top-left corner of the title bar, right next to the save icon. They are represented by curved arrows pointing left (Undo) and right (Redo).

Just be aware: The Undo feature has its limits. It primarily works for changes made to the report canvas - like formatting, adding/deleting visuals, and modifying properties. It does not work for all actions, especially those made in the Power Query Editor or DAX editor. Crucially, once you save your file, close Power BI Desktop, and reopen it, your undo history is cleared.

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

Navigating Your Changes in Power Query Editor

The Power Query Editor is where you clean and transform your data, and it has its own powerful "go back" system called "Applied Steps." This is your timeline for every data transformation you've made.

Every time you filter a column, remove rows, change a data type, or merge tables, Power Query records that action as a distinct step in the "Applied Steps" pane on the right side of the screen. This allows you to go back in time and see how your data looked before a specific transformation.

How to Use Applied Steps

Let's walk through an example. Imagine you're cleaning up a simple sales data table.

1. You open the Power Query Editor (click "Transform data" on the Home ribbon).
2. In the "Applied Steps" pane, you see your starting steps, like Source and Navigation.
3. You decide to remove a column called "Discount." Power Query adds a new step "Removed Columns."
4. Next, you filter the "Country" column to only show "USA." Power Query adds another step: "Filtered Rows."

Now, your "Applied Steps" pane looks something like this:

• Source
• Navigation
• Removed Columns
• Filtered Rows

How to "Go Back"

• To see your data before a step: Simply click on a previous step in the list. For example, if you click on "Removed Columns," the data preview will update to show you the table before you applied the "USA" filter. This lets you inspect how your data changed at each stage without actually deleting the step.
• To delete a step entirely: Click the 'X' icon next to the step you want to remove. If you decide you actually need the "Discount" column, you can click the 'X' next to the "Removed Columns" step, and that column will reappear in your data.

Heads Up: Be careful when deleting steps from the middle of your list. If a later step depends on a step you deleted (e.g., you renamed a column and then changed its data type), deleting the rename step will cause an error in the data type step. Power Query will warn you before you delete a step that might affect subsequent ones.

Creating a "Back" Button for Report Navigation

Sometimes "going back" isn't about undoing a mistake - it's about creating a smooth user experience. If your report has multiple pages, especially drill-through pages, providing users with an intuitive "Back" button is crucial for navigation.

Power BI has a built-in "Back" button type that automatically remembers the previous page a user was on.

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

How to Add a Smart Back Button

1. Navigate to the page where you want to place the button (e.g., a "Sales Details" page that users drill through to).
2. From the top ribbon, go to the Insert tab.
3. In the Elements section, click on Buttons and select Back.
4. A back arrow icon will appear on your report canvas. You can drag and resize it like any other visual.

That's it! This button is now context-aware. If a user navigates from your "Overview" page to your "Sales Details" page, clicking this button will take them right back to the "Overview" page. In Power BI Desktop, you'll need to hold Ctrl + Click to use the button. Once published to the Power BI service, users can just click it normally.

Customizing Your Back Button

To make the button clearer, you can format it using the "Format" pane:

• Style: Change the icon's shape, color, and rotation.
• Text: Turn on the Text property and type something like "Go Back" or "Return to Summary." Adjust the font, color, and size to match your report's design.
• Tooltip: Add helper text that appears when a user hovers over the button, such as "Click to return to the previous page."

The Ultimate "Go Back": Reverting to Previous File Versions

What if you make a huge series of changes, save the file, and then realize you've made a catastrophic mistake? The Ctrl+Z command won't help you here. This is where version control becomes a lifesaver.

While Power BI Desktop doesn't have a direct "File > Version History" option, you can get this functionality simply by where you choose to store your .pbix file. Saving your reports to a version-controlled cloud service like OneDrive for Business or SharePoint is the most reliable way to recover from major errors.

How to Use SharePoint/OneDrive Version History

1. Save your .pbix file in a folder that is synced to either your OneDrive for Business account or a SharePoint document library.
2. Work as usual. Every time you save your .pbix file in Power BI Desktop, the cloud service automatically logs it as a new version in the background.
3. To restore a previous version:
4. A pane will appear showing a list of saved versions, with timestamps and the name of the person who modified them.
5. You can click the three dots next to any previous version to either Restore it (making it the current version) or Download a copy to inspect it before restoring.

Adopting this practice is one of the best habits you can form as a Power BI developer. It protects you from accidental deletions, bad data model changes, or any other mistake that can't be fixed with a simple undo.

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

Using Drill Up to Go Back in Visual Hierarchies

The final way to "go back" is within a visual itself. When you're analyzing data, you often drill down from a high-level summary into more granular details. Going back up is just as important.

For example, you might have a visual that shows total sales by 'Year'. If that column is part of a date hierarchy (Year > Quarter > Month > Day), you can drill down to see sales by Month. 'Drill Up' is the action that takes you back to viewing sales by 'Year'.

How Drill Up Works

1. Select a visual that has a data hierarchy in its axis (e.g., a bar representing a specific year).
2. At the top of the visual, you'll see a series of arrows. Click the single downward arrow to turn on "Drill Mode," then click a data point (like the bar for 2023) to drill down to the next level (quarters).
3. To go back up, click the single upward-pointing arrow (Drill Up logo) at the top of the visual. This will take you immediately back to the previous level in your hierarchy (from quarters back to years).

This method of "going back" is fundamental for data exploration, allowing you to seamlessly move between summary and detailed views to find insights.

Final Thoughts

Knowing how to go back in Power BI, whether it’s through a simple Ctrl+Z, reverting a transformation in Power Query, or restoring a previous file version, empowers you to build reports with more confidence. Mastering these different techniques ensures no mistake is permanent and you can always navigate back to a known-good state.

While mastering these features is a valuable skill, we know how time-consuming and complex building reports - and then fixing them - can be. So at Graphed, we’ve focused on making data analysis as easy as asking a question. Instead of clicking through menus to undo a step or format navigation buttons, you can simply describe what you want in plain English. Our AI will instantly build interactive, live-updating dashboards from your connected data sources, allowing you to skip the tedious work and focus on the insights.