How to Make a Graph in Power BI

Building your first graph in Power BI can feel intimidating, but it's simpler than you might think. This guide will walk you through the essential steps to turn your raw data into clear, insightful charts, from importing your information to customizing your final visualization. We'll cover everything a beginner needs to get started creating professional-looking reports.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First Things First: Getting Your Data into Power BI

Before you can make a graph, you need data to visualize. Power BI connects to hundreds of data sources, but for this tutorial, we'll stick to the most common scenario: importing an Excel or CSV file. This is the foundation for everything that follows.

Let's say you have a simple sales report in an Excel sheet with columns like Date, Product Category, Region, and Sales Amount.

1. When you open Power BI Desktop, you'll see a welcome screen with options to get data. You can either select "Import data from Excel" directly from this screen or close it and look at the main toolbar.
2. In the Home tab of the ribbon, click the Get Data button. A dropdown menu will appear with common data sources.
3. Select Excel workbook (or Text/CSV if that's what you have).
4. A file explorer window will open. Navigate to your file, select it, and click Open.
5. The Navigator window will pop up, showing you the sheets or tables within your file. Select the sheet containing your data (e.g., 'Sheet1' or 'SalesData').
6. Power BI will show you a preview. If it looks correct, click Load. If your data needs cleaning (like removing empty rows or fixing column headers), you would click Transform Data, but we'll keep it simple for now.

Once you click Load, Power BI will work for a moment and then your data fields will appear in the Data pane on the right-hand side of the screen. You're now ready to start graphing!

Navigating the Power BI Interface (The Quick Tour)

The Power BI Desktop screen has three main areas you'll use constantly. Getting familiar with them makes the whole process smoother.

• The Canvas: This is the large, blank white space in the middle. It's where your graphs and visuals will live. Think of it as a painter's canvas.
• The Visualizations Pane: Just to the right of the canvas, this is your toolbox for creating graphs. It contains icons for every type of chart available, like bar charts, line charts, pie charts, and maps. Below the icons are the "wells" (fields) where you'll drag your data, such as Axis, Values, and Legend.
• The Data Pane: Farthest to the right, this pane lists all the tables and data columns (which Power BI calls "fields") you loaded. This is where you'll grab the data pieces you want to visualize.

Your workflow will typically be: pick a visual from the Visualizations pane, then drag fields from the Data pane into the wells of that visual to build your chart on the Canvas.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Creating Your First Graph: A Simple Bar Chart

Bar and column charts are the workhorses of data visualization. They are excellent for comparing values across different categories. Let's create a bar chart to see total sales for each region.

Step 1: Select the Chart Type

In the Visualizations pane, find the icon for the stacked bar chart or stacked column chart. Click on it. A blank placeholder for the visual will appear on your canvas.

Step 2: Add Your Data

Now, look over at your Data pane on the right. You should see your sales data table with all its columns listed underneath.

• We want to see sales by Region. Find the Region field and drag it into the Y-axis well (for a bar chart) or the X-axis well (for a column chart) in the Visualizations pane.
• Next, we need the values to measure. Find the Sales Amount field and drag it into the X-axis well (for a bar chart) or the Y-axis well (for a column chart).

As soon as you drop the fields into place, Power BI will automatically generate the chart on your canvas. You should now see a simple bar or column chart showing the total sales amount for each of your regions. That's it - you've officially created your first graph!

Building Other Common Chart Types

Once you understand the drag-and-drop method, creating other chart types follows the same pattern. You just need to select a different visual and put the right kind of data into the wells.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Creating a Line Chart to See Trends Over Time

Line charts are perfect for showing how a value changes over a continuous period, like days, months, or years.

1. First, make sure no visual on your canvas is selected by clicking on an empty area.
2. In the Visualizations pane, click the Line chart icon. A new blank visual will appear.
3. Drag the Date field from the Data pane into the X-axis well. Power BI is smart and will often create a date hierarchy for you (Year, Quarter, Month, Day), allowing you to drill up and down.
4. Drag the Sales Amount field into the Y-axis well.

Instantly, you'll see a line chart visualizing your sales performance over time. This is a powerful way to spot seasonality, growth trends, or sudden dips.

Making a Pie Chart for Proportions

Pie charts are useful when you want to show how parts contribute to a whole, like an analysis of market share or budget allocation. Let's see which product category contributes the most to sales.

1. Click on a blank part of the canvas, then select the Pie chart icon from the Visualizations pane.
2. Drag the Product Category field into the Legend well. This will define the "slices" of the pie.
3. Drag the Sales Amount field into the Values well. This will determine the size of each slice.

You'll now have a pie chart where each slice represents a product category, sized according to its percentage of total sales. A word of caution: pie charts become hard to read with more than 5 or 6 categories. In those cases, a bar chart is usually a better choice.

Customizing Your Graph for a Professional Look

The default Power BI charts are functional, but a little customization can make them much cleaner, easier to understand, and match your brand's style.

With a visual selected, click the Format your visual icon in the Visualizations pane (it looks like a paintbrush). This opens up a world of formatting options.

• General: Here, you can change the chart's Title, a hugely important step. Make it clear and descriptive (e.g., "Total Sales by Region"). You can also adjust fonts, colors, and background settings.
• X-axis / Y-axis: You can turn axes titles on or off, change the color and size of the text, and adjust the range of values shown on a numerical axis.
• Legend: Toggle the legend on or off, change its position (e.g., Top, Bottom, Right Center), and format its text.
• Bars / Columns / Lines: This section lets you change the color of your data. You can either select new colors for all bars or use conditional formatting to make bars change color based on their value (e.g., make the highest sales bar a different color).
• Data labels: Turn these on to show the exact value of each bar, slice, or data point directly on the chart. This often saves your audience from having to guess values based on the axis.

Experimenting with these settings is the best way to learn. Don't be afraid to click around - you can always reset to default if you make a mess.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Quick Tips for Making Better Graphs

Knowing how to create a graph is one thing, creating an effective graph is another. Keep these principles in mind:

1. Start with a Question: Before you even drag a field, ask yourself, "What question am I trying to answer with this data?" This focus will guide you to choose the right chart and data points. For example, "Which marketing campaigns have the best ROI?" immediately tells you that you'll need 'Campaign Name' and 'ROI' in your visual.
2. Choose the Right Chart for the Job: Don't just pick what looks cool. Use bar/column charts for comparisons, line charts for trends over time, pie charts for part-to-whole relationships, and scatter plots for exploring relationships between two numerical values.
3. Keep It Simple: The most common mistake is cluttering a chart with too much information. Avoid using 3D effects, busy background images, or too many colors. The goal is clarity, not artistic complexity. The data should be the star of the show.
4. Label Everything Clearly: Your graph should stand on its own without needing a lengthy explanation. A descriptive title, clear axis labels, and a visible legend are non-negotiable.

Final Thoughts

You've now seen how to connect your data, navigate the interface, and create fundamental charts like bar graphs, line charts, and pie charts in Power BI. By following these steps and applying a few design best practices, you can quickly move from a static spreadsheet to a dynamic and interactive report that tells a clear story with your data.

While Power BI is incredibly powerful, there's admittedly a learning curve to creating even simple dashboards. If you're a marketer or business owner who needs answers fast without spending hours clicking and dragging fields, we built Graphed to solve this problem. Instead of navigating formatting panes, you can just ask a question like, "Show me monthly sales trends as a line chart" or "Create a bar chart comparing Facebook ad spend to sales revenue by campaign," and the dashboard is built for you instantly using real-time insights from your tools like Google Analytics, Shopify, and Salesforce.