How to Edit a Table in Power BI

Trying to edit a table directly in Power BI's main report view can feel like trying to change a tire while the car is moving. If you're used to tweaking data in something like Excel or Google Sheets, Power BI works a bit differently. This guide will walk you through the proper way to edit and transform your tables using Power BI's powerful, built-in tool: the Power Query Editor.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

We’ll cover the most common edits you'll need, from simple column renaming and data type changes to more advanced steps like creating conditional columns. You'll learn how to get your data cleaned up and ready for building beautiful, insightful reports.

Getting Started: Accessing the Power Query Editor

Most of the heavy lifting for data editing in Power BI happens in a separate window called the Power Query Editor. Think of this as the backstage area or the kitchen of your report. It’s where you chop, season, and prepare your data ingredients before you present them on a dashboard. Any changes you make here are applied to the data before it loads into your main report for visualization.

Here’s how to open it:

1. On the main Power BI Desktop screen, make sure you’re in the Report view.
2. Go to the Home tab in the top ribbon.
3. Click the Transform data button. This will launch a new window: the Power Query Editor.

Once you’re in, you’ll see your data laid out in a familiar table format. This is where the magic happens.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Common Table Edits: Your Power Query Toolkit

Inside the Power Query Editor, you have a vast array of tools at your disposal. They are located in the top ribbon under tabs like Home, Transform, and Add Column. Let's walk through the most essential transformations you'll use day-to-day.

Renaming Columns

Often, data comes in with messy or unclear column headers like cust_first_name or Transaction_Value-USD. Cleaning these up makes your final reports much easier to read.

• How to do it: Simply right-click the header of the column you want to rename and select Rename from the dropdown menu. You can also double-click the column header. Type the new name and press Enter.
• Example: Renaming the column GA_sessions_L30D to a much friendlier 30-Day Website Sessions.

Changing Data Types

Power BI is pretty good at guessing data types (Text, Whole Number, Decimal Number, Date, etc.), but it doesn't always get it right. For instance, a column of dates might be accidentally interpreted as plain text, which means you can't use it on a time-based chart. A revenue column saved as text won't do you any good if you need to calculate sums or averages.

• How to check: Each column header has a small icon indicating its current data type (e.g., "ABC" for Text, "123" for Whole Number, a calendar for Date).
• How to do it: Click the icon next to the column header. A dropdown menu will appear with all the available data types. Select the correct one for your data. Power BI will then re-evaluate the column based on that type.
• Example: A Date column might be set to Text. Click the "ABC" icon and change it to Date. The data will now be correctly interpreted for time-series analysis.

Removing Columns and Rows

Not all data is useful. Your source file might contain extra columns that just clutter your report, or it might have blank rows or unwanted entries that need to be filtered out.

Removing Columns

• How to do it: Select the column (or multiple columns by holding Ctrl) that you want to delete. Right-click on one of the selected headers and choose Remove. Alternatively, you can select the columns and click the Remove Columns button in the Home tab of the ribbon.
• Example: Your data export from Salesforce includes internal ID columns like AccountId and ContactId that you don't need for your sales dashboard. You can simply remove them to simplify your dataset.

Filtering and Removing Rows

• How to do it: Click the downward arrow on the right side of the column header you want to filter. This opens a filter pane similar to Excel. You can uncheck the values you want to exclude or use more advanced text, number, or date filters (e.g., "does not equal," "is greater than," "is in the last 30 days").
• A common use case is removing blank rows. To do this, click the filter arrow and select Remove Empty from the cleanup options.
• Example: You have a sales report with a few rows where the Revenue column is null or zero. You can filter the Revenue column to show only values "greater than 0" to exclude these empty or incomplete transaction records.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Replacing Values

Typos, inconsistent capitalization, or variations in naming can throw off your analysis. "USA," "U.S.A.," and "United States" may be the same thing to a human, but Power BI sees them as three distinct values. The "Replace Values" feature is your solution.

• How to do it: Right-click on a column header and navigate to Replace Values. A dialog box will pop up. In "Value To Find," type the text you want to get rid of. In "Replace With," type the text you want to use instead. Click OK.
• Example: In your marketing campaign data, some entries are labeled "Facebook" and others are labeled "FB." You can use Replace Values to find all instances of "FB" in the Source column and replace them with "Facebook" for consistency.

Adding a Conditional Column

Sometimes you need to create a new column that categorizes your data based on the values in other columns. This is perfect for grouping, segmenting, or bucketing your data without having to edit the original source file. This is one of the most powerful features in Power Query.

• How to do it: Go to the Add Column tab in the ribbon and click Conditional Column.
• What it is: A user-friendly pop-up will appear that lets you build IF...THEN...ELSE logic without writing any code. You can set up rules like: IF the Sales Value column is greater than 1000, THEN in our new column, the output should be "Large Deal," ELSE the output should be "Standard Deal."
• Example: Let's create a geography segment.

The "Applied Steps" Pane: Your Secret Weapon

Have you ever been making changes in Excel and realized you made a mistake ten steps ago, with no way to undo it besides starting over? Power BI solves this beautifully with the Applied Steps pane.

On the right side of the Power Query Editor, you'll see a list for "Applied Steps." Every single transformation you make - renaming a column, filtering a row, changing a data type - is recorded as a step in this list. It’s a complete history of your data cleaning process.

This is incredibly useful for two reasons:

1. It's an undo button on steroids: To reverse a transformation, simply click the 'X' next to that step in the list. The step (and only that step) will be removed.
2. It makes your work repeatable: The next time you refresh your data, Power BI will automatically re-apply all those steps in the exact same order. This means you only have to clean your data once, automating the process for all future updates.

Remember to Close and Apply!

Once you’re finished transforming your data in the Power Query Editor, your changes are not yet available in your main report. You need to save and apply them.

In the Home tab of the Power Query Editor, click the Close & Apply button in the top-left corner. This will close the editor and load your freshly cleaned and transformed data into Power BI's data model, ready for you to build visualizations.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Final Thoughts

Editing tables in Power BI is all about using the Power Query Editor to shape your raw data before visualizing it. By getting comfortable with renaming columns, filtering rows, and adding conditional logic, you can transform messy source files into a clean, reliable dataset. The best part is the "Applied Steps" feature, which not only tracks your changes but also automates the entire cleaning process for you every time you refresh your report.

While Power BI is incredibly powerful, there is no denying its learning curve. Mastering all the nuances of Power Query can sometimes feel like a full-time job, especially when you just need quick answers about your marketing or sales data without endless clicking and configuration. That’s why we built Graphed . We turn hours of data prep and dashboard building into a simple conversation. Just connect your platforms like Google Analytics, Shopify, and Salesforce, then ask for what you need in plain English - like "create a dashboard comparing Facebook Ads spend vs. revenue by campaign this month." We build the live, auto-updating dashboard for you in seconds, saving you from the complex setup of traditional BI tools.