How to Edit Power BI Report in Desktop

Opening an existing Power BI report can feel like being handed the keys to a spaceship - it’s powerful, full of buttons and dials, and a little intimidating if you don't know what you're doing. But once you get familiar with the controls, you can pilot it anywhere you want. This guide will walk you through editing a report in Power BI Desktop, breaking down the process from simple visual changes to refining the data you display.

Getting Your Bearings: The Power BI Desktop Interface

Before you start making changes, let's do a quick tour of the main work area in Power BI Desktop. Understanding the layout is the first step to editing with confidence.

Over on the left-hand side, you'll see three primary views:

• Report View: This is your main canvas where you'll spend most of your time. It’s where you arrange, format, and interact with all the charts and tables that make up your report.

• Data View: Think of this as a lightweight spreadsheet view of your data. You can inspect the columns and rows of each table loaded into your model. It's useful for understanding what data you have available.

• Model View: This view shows you how your data tables are connected to each other through relationships. It’s a more advanced area you won’t need for simple visual edits, but it’s good to know it's there.

On the right-hand side, a few panes are critical for editing:

• Fields Pane: This is a list of all the tables and data columns available for you to use. You’ll drag items from here onto your visuals to build or modify them.

• Visualizations Pane: This is your command center for visuals. It lets you change the type of chart (e.g., from a bar chart to a line chart) and manage the data fields that power the selected visual.

• Filters Pane: This area allows you to apply filters to a specific visual, an entire page, or even the entire report.

Core Editing Task 1: Modifying Visuals

The most common edits you'll make involve changing the look and feel of existing visuals (also known as "visualizations" or "charts").

How to Change a Visual Type

Maybe a bar chart isn't telling the story you want, and a line chart would be better for showing a trend over time. Changing it is simple.

1. Click on the visual you want to change. A bounding box will appear around it, indicating it's selected.

2. Go to the Visualizations pane. You will see a grid of icons, with the current visual type highlighted.

3. Simply click a different icon to change the type. For example, click the line chart icon, and Power BI will instantly transform your bar chart into a line chart, doing its best to map the existing data fields correctly.

Pro Tip: Not all visual types work with all data combinations. If the change looks weird, it might be because the new chart type requires a different data structure. Don't be afraid to try a few options or switch it back.

Adding or Removing Data from a Visual

What if you want your sales bar chart to show "Profit" in addition to "Sales amount"? Or maybe you need to remove a field that's cluttering the chart.

1. Select the visual you want to edit.

2. In the Visualizations pane, look just below the icons. You'll see several "wells" or boxes, such as Y-axis, X-axis, and Legend. These contain the data fields currently used in the chart.

3. To remove a field: Hover over the field name in its well and click the 'X' that appears.

4. To add a field: Look at the Fields pane on the far right. Find the data field you want to add (e.g., "Profit") and drag it into the desired well in the Visualizations pane. For instance, dragging "Profit" into the Y-axis well on a bar chart will add a new bar for profit next to the existing one for sales.

Resizing and Moving Visuals

You can rearrange the report canvas just like you would with slides in PowerPoint.

• To move a visual: Click and drag the visual from its center to a new position on the page.

• To resize a visual: Select the visual and drag the small handles that appear on its corners and sides to make it larger or smaller.

Core Editing Task 2: Formatting and Customizing Your Report

Getting the data right is one thing, making it look clean and professional is another. The "Format your visual" tab is where you handle titles, colors, labels, and more.

Finding the Formatting Options

1. Select the visual you wish to format.

2. In the Visualizations pane, click the paintbrush icon. This switches you from the data wells to the formatting options.

You’ll see different sections you can expand, such as General, X-axis, Y-axis, and Data colors. Let's look at a common example.

Example: How to Edit a Chart Title

1. With a visual selected, go to the Format your visual tab (the paintbrush).

2. Expand the General section.

3. Click to expand the Title sub-section.

4. In the Text box, you can type in your new, more descriptive title.

5. You can also change the font, text color, alignment, and size right here.

Use this same method to explore other options. Go to the Data colors section to change the bar or line colors, or go to the Data labels section to turn on labels that show the exact value for each data point.

Core Editing Task 3: Adjusting Data and Adding Calculations

Sometimes you need to do more than just change how data is presented, you need to change the data itself, often by way of filters or simple calculations.

How to Apply Filters

Maybe your report shows global sales, but you only want to see data for Canada. The Filters pane is your best friend for this.

1. Select the chart you want to filter. If you want to filter the whole page, click on a blank part of the report canvas instead.

2. Go to the Filters pane. You'll see areas for "Filters on this visual," "Filters on this page," and "Filters on all pages."

3. Find the field you want to filter by in the Fields pane (e.g., "Country").

4. Drag that "Country" field into the "Filters on this visual" box (or another box, depending on your goal).

5. Change the Filter type to "Basic filtering" to get a simple checklist of all available countries. Check the box for "Canada" to update the visual.

Creating Simple Measures with DAX

Sometimes the specific number you need doesn't exist as a neat column in your data. For example, there's a "Sales" column and a "Profit" column, but what you really want to see is the "Profit Margin." This requires a new calculation, known as a measure.

While DAX (Data Analysis Expressions), Power BI's formula language, can be very advanced, creating a simple measure is straightforward.

1. In the Fields pane, right-click on the table where you want the measure to live (e.g., the "Sales" table).

2. Select New measure.

3. A formula bar will appear at the top. Here, you'll write your DAX formula. For a profit margin, it might look like this:

Profit Margin = DIVIDE(SUM(Sales[Profit]), SUM(Sales[Sales amount]))

1. Press Enter to save the measure. A new item with a small calculator icon will appear in your Fields pane. You can now drag this "Profit Margin" measure into any visual just like any other field!

2. To show it as a percentage, select the new measure in the Fields list, and from the "Measure tools" ribbon at the top, change the format to Percentage.

Core Editing Task 4: Managing Report Pages

Your report is like a workbook with multiple tabs or pages. Editing them is easy.

• Renaming a page: Double-click the page name in the tab at the bottom of the screen and type a new one.

• Adding a new page: Click the '+' icon in the tabs area to add a blank new page.

• Duplicating a page: Right-click a page tab and select "Duplicate page." This is a huge time-saver if you want to create a similar layout or just experiment safely.

• Reordering pages: Just click and drag the page tabs to change their order.

Saving and Publishing Your Hard Work

Once you've made your edits, you have two main options:

1. Save: Hitting the save icon saves all your changes to the .pbix file on your computer. This is a local file only you can see.

2. Publish: The Publish button (on the Home tab of the ribbon) pushes your report to the Power BI Service - the cloud-based version of Power BI. This is how you share your updated report and dashboards with colleagues and stakeholders. Once published, others will be able to view and interact with the new version through their web browser.

And that’s it! With these foundational editing skills, you’re well on your way to taking any Power BI report and tailoring it to your exact needs.

Final Thoughts

Editing a Power BI report comes down to getting comfortable with its primary panes: Fields, Visualizations, and Filters. By understanding how to select an object, find its options, and drag in the data you need, you can transform a generic report into a sharp, insightful tool that answers your most important business questions.

While mastering programs like Power BI is a valuable skill, it often involves a steep learning curve and a whole lot of manual work adjusting settings just to answer a simple question. At Graphed, we remove this friction entirely. We built a tool that lets you create dashboards and get analysis just by using plain English - no wrestling with formatting panes required. You just connect your marketing and sales data, then ask things like, "Show me last quarter's revenue from Facebook Ads campaigns," and get a live, interactive dashboard built for you instantly.