How to Make a Chart in Power BI

Creating your first chart in Power BI is a lot easier than you might think. Whether you're trying to visualize sales data, track website traffic, or understand customer trends, Power BI turns raw numbers into clear, interactive visuals. This guide will walk you through the entire process, from getting your data into the app to customizing your first chart to make it shine.

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

First Things First: Getting Your Data into Power BI

Before you can build anything, you need data. Power BI can connect to an incredible number of data sources, but for beginners, the most common starting point is a simple spreadsheet like an Excel or Google Sheets file. Let's start there.

Connecting to Your Data Source

The first screen you'll often see in Power BI Desktop is a splash screen asking you to import data. You can also always find the "Get Data" option in the main ribbon at the top of the application. The process is straightforward and gets your raw material ready for visualization.

Here’s how to connect to an Excel workbook:

• Open Power BI Desktop. In the Home ribbon, click on Get Data. A dropdown menu will appear.
• Select Excel workbook. This is one of the most common options, so it’s usually near the top.
• A file explorer window will appear. Navigate to the Excel file you want to use and click Open.
• Power BI will then open a Navigator window. This window shows you all the sheets and tables inside your Excel file.
• Select the sheet or table containing the data you want to analyze. Power BI will show you a preview of your data on the right.
• Once you're happy with your selection, click Load. If your data is messy, you might use Transform Data to clean it up first, but for now, let's assume your data is ready to go.

Power BI will now load your data into the model. In moments, you'll be ready to start building.

A Quick Tour of the Power BI Report View

Once your data is loaded, you'll land in the Report View. This is your canvas where all the visual magic happens. It might look a little intimidating at first, with a few different panes and buttons, but you only need to focus on three key areas to start making charts.

1. The Fields Pane

On the far right, you'll see the Fields pane. This is where your data lives. Every column from your spreadsheet is now listed here as a "field." You'll see fields for things like Date, Product Name, Sales Revenue, and Region. This is your palette of ingredients for building your charts.

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

2. The Visualizations Pane

Just to the left of the Fields pane is the Visualizations pane. Think of this as your toolbox. It’s filled with icons for different types of charts and graphs: bar charts, line charts, pie charts, maps, and many more. This is where you’ll select the type of chart you want to build and configure it.

3. The Report Canvas

The large blank area in the middle is your Report Canvas. This is where you'll drag and drop fields to build, arrange, and resize your charts. You can create a single visualization or build a full multi-chart dashboard on this canvas.

Creating Your First Chart: A Step-by-Step Guide

Now for the fun part. Let's build a simple column chart to show sales performance across different product categories. This is a classic visual that nearly every business uses.

Step 1: Select Your Chart Type

Go to the Visualizations pane and click on the icon for a Stacked column chart. It looks like a little vertical bar graph. When you click it, Power BI will add a blank placeholder for that chart onto your canvas.

Step 2: Add Your Data

With the new blank chart selected, look over at your Fields pane. Find the field you want to analyze (the "what," also called the measure) and the field you want to analyze it by (the "how," also called the dimension).

• Let’s say we want to see Sales Revenue by Product Category.
• Find the Sales Revenue field in your Fields list and drag it onto the "Y-axis" well in the Visualizations pane. The Y-axis is typically for numerical values.
• Next, find the Product Category field and drag it onto the "X-axis" well. The X-axis is for your categories.

Instantly, the blank placeholder on your canvas transforms into a fully-functional column chart! Each bar represents a product category, and the height of the bar shows the total sales revenue for that category. It’s that simple.

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

Making Your Chart Look Good: Customization Tips

The default chart Power BI creates is functional, but now you can make it easier to read and more visually appealing. The key is the little paintbrush icon in the Visualizations pane, called Format your visual.

Formatting Titles and Labels

A good chart explains itself. Your default title will likely be something generic like "Sum of Sales Revenue by Product Category." Let's make it clearer.

• With your chart selected, click the Format your visual icon.
• Expand the Title section.
• Under the Text box, type in something better, like "Annual Sales by Product Category." You can also change the font, text size, and color here.
• You can do the same for the X-axis and Y-axis titles to make them cleaner, or even turn them off if the main title is clear enough.
• To show the exact value for each bar, go to the Data labels section and toggle it to On. The sales figures will appear on top of or inside each bar, providing viewers with instant clarity.

Changing Colors and Legends

Colors can draw attention to key data points. The default blue is fine, but you might want to use your brand colors or highlight a specific category.

• In the Format your visual tab, expand the Columns section.
• Here you can change the color of all the bars at once, or use the "Show all" toggle to assign a unique color to each individual category.
• If you add another dimension (for example, dragging "Region" into the Legend field), Power BI will create stacked or clustered bars showing sales by category and region. The legend colors can be managed in the Legend section of the format pane.

Sorting Your Data

By default, your chart might be sorted alphabetically by category name. It’s often more useful to sort by the value, so you can quickly see top and bottom performers.

• Hover over your chart until you see three dots (...) appear in the top-right corner. This is the More options menu.
• Click it, go to Sort axis, and choose which field you want to sort by (e.g., "Sales Revenue").
• You can then choose Sort descending to put the highest-selling category first, or Sort ascending to show the lowest performer first.

Switching Things Up: Trying Different Chart Types

One of the most powerful features in Power BI is how easily you can change a chart's format. What if a bar chart isn't the best way to tell your story?

With your chart selected, simply click on a different icon in the Visualizations pane. Power BI will instantly transform your existing chart into the new type without losing your data configuration.

• Click the Pie chart icon, and your bar chart instantly becomes a pie chart showing the percentage of total sales for each category.
• If you have time-series data (like sales per month), select the Line chart icon to see trends over time.
• If your data includes geographical information like city or state, try the Map visual to plot your sales data on an interactive map.

This flexibility encourages experimentation and helps you find the perfect way to present your insights.

Next-Level Charting: A Few Extra Tips

Once you are comfortable with the basics, here are a few more tips to make your charts even more interactive and insightful.

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

Deepen Insights with Tooltips

Tooltips are the small boxes that pop up when you hover over a data point. By default, they show the axis and value. You can add more context by dragging other fields into the Tooltips well in the Visualizations pane. For example, drag Profit Margin into the tooltip well, and now when you hover over a category bar, you'll see both its total sales and its profit margin.

Use Filters to Narrow Your Focus

The Filters pane, located next to the Visualizations pane, lets you slice your data. You can apply filters to a specific chart or to the entire report page. Simply drag a field into the Filters pane (e.g., Year) and select a specific value (e.g., 2023) to see data for just that year.

Final Thoughts

You did it! You've successfully gone from a raw data file to a polished, insightful chart in Power BI. By following these steps, you can start building clear and compelling reports that help you and your team make smarter, data-driven decisions. The key is to start simple, experiment with different visual types, and focus on making the information easy to understand.

As you scale your reporting, you might find that even the powerful, drag-and-drop workflow in tools like Power BI can feel time-consuming - especially when juggling data from multiple marketing and sales platforms. We built Graphed to solve this. Instead of clicking through menus to build your visuals, you can just ask for what you want in plain English, like "Show me a chart of sales by product category." We connect directly to your data sources like Google Analytics, Shopify, and Salesforce to instantly build live, interactive dashboards, saving you the hours typically spent on manual report building.