How to Make a Clustered Column Chart in Power BI

One of the most useful visuals you can create in Power BI is the clustered column chart. It’s a workhorse for comparing a primary category against a secondary one, like seeing your product sales broken down by region or tracking quarterly revenue across different marketing campaigns. This article is your complete guide to creating one from scratch, formatting it to look professional, and using a few advanced tips to make your reports even more insightful.

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

What is a Clustered Column Chart?

A simple column chart uses vertical bars to show a value for a single category. For example, you could show total sales for each quarter. A clustered column chart takes this a step further by grouping, or "clustering," multiple bars together. This allows you to compare sub-categories within a larger category.

Imagine you have sales data for different product lines (e.g., Laptops, Desktops, Accessories) across several quarters. A clustered column chart would group the bars for each product line together under each quarter. This lets you see two things at once:

• How total sales are changing each quarter.
• Which product line is the biggest contributor to sales in any given quarter.

So, when should you use one? Clustered column charts are ideal when you want to compare values across at least two different categories, especially when one of those categories has a moderate number of distinct items (usually 2-5 for the "cluster").

Getting Your Data Ready

Before jumping into Power BI, make sure your data is structured properly. You don’t need anything complicated. To build a standard clustered column chart, your dataset should have at least three columns:

• A Text Category: This will be your main grouping along the bottom (horizontal) axis. Think of things like Year, Quarter, Country, or Sales Rep.
• A Comparison Category: This second text category defines the individual bars within each cluster. This could be Product Category, Campaign Name, or Lead Source.
• A Numeric Value: This is the number you want to measure and what determines the height of your bars. Examples include Sales Revenue, Number of Units Sold, or Website Sessions.

Having clean data organized this way makes the entire creation process in Power BI incredibly smooth.

Step-by-Step: Creating a Clustered Column Chart

Let's build one together. For this example, we’ll use a simple sales dataset with columns for Sales Date, Region, Product Line, and Revenue.

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

Step 1: Open Power BI and Load Your Data

Start by launching Power BI Desktop. If this is a new report, the first thing you need to do is connect to your data source. You can do this by clicking Get Data on the Home ribbon. Find and select your data source (e.g., Excel workbook, SQL server) and follow the prompts to load your table into the model.

Once loaded, you’ll see your table and its fields listed in the Data pane on the right-hand side of the screen.

Step 2: Select the Clustered Column Chart Visual

Now, click on the report canvas (the blank white area). In the Visualizations pane, find the icon for the clustered column chart. It looks like several vertical bars of different colors right next to each other. Click it to add an empty chart visual to your canvas.

Step 3: Drag and Drop Your Fields

With the empty visual selected, you’ll see several field wells underneath the list of visualizations: X-axis, Y-axis, and Legend. This is where you tell Power BI how to build the chart.

• Drag your main category field (in our example, Region) from the Data pane into the X-axis well. This sets up the main groups along the bottom of the chart.
• Drag your numeric value field (Revenue) into the Y-axis well. At this point, you have a simple column chart showing total revenue by region.
• Now for the most important step: drag a second category (Product Line) into the Legend well. You will immediately see the single bars for each region split into colored clusters representing each product line.

And that’s it! You've successfully created a basic clustered column chart showing revenue by region, broken down by product line.

Customizing Your Chart for Clarity and Impact

A functional chart is good, but a clear, easy-to-read chart is even better. Power BI offers extensive formatting options to make your visuals look professional. With your chart selected, click the Format your visual icon (it looks like a paintbrush) in the Visualizations pane.

Give Your Chart a Great Title

The default title will be something technical like "Sum of Revenue by Region and Product Line." That's not very helpful. You want a title that tells a story. Navigate to General → Title and write something more descriptive, like "Quarterly Revenue Growth Driven by Laptop Sales." This gives immediate context to anyone looking at your report.

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

Adjusting the X and Y-Axis

In the Format tab in the format pane, you'll find sections for the X-axis and Y-axis. Here you can:

• Increase the font size and change the font color for a cleaner look.
• Turn axis titles on or off. It's good practice to have them on unless the context is clear.
• For the Y-axis, you can change the display units (from thousands to millions, for example) and add a dollar sign ($) if you're visualizing currency.

Choosing Your Brand Colors

Default colors are often fine, but you can tailor them to your company's branding or to highlight specific information. Go to the Columns section. Here, you can click on the color next to each legend item (e.g., 'Laptops,' 'Desktops') and choose a new one. This personalization makes reports feel more polished and professional.

Adding Data Labels

Sometimes, it's useful to see the exact value of each bar without having to hover over it. You can achieve this by turning on Data Labels. You'll find the toggle in the formatting options. Once enabled, you can customize the font, display units, and position of the labels to make sure they are readable and don’t clutter the chart.

Customizing Tooltips

Tooltips are the little windows of information that appear when you hover over a data point. By default, they show the values you used to build the chart. You can add more context by dragging other fields into the Tooltips field well (right below the Legend field). For instance, you could drag in an Order Count field so that when you hover over a revenue bar, you also see how many orders contributed to that revenue.

Advanced Tips and Best Practices

Ready to go beyond the basics? These advanced features can transform your reports from simple data displays into powerful analytical tools.

Level Up with Small Multiples

Small Multiples splits your chart into a grid of smaller versions of itself, with each one representing a different category. For example, if you have a Sales Manager field, you can drag it to the Small multiples field well. Power BI will then create a separate clustered column chart for each manager, all on display at the same time. This is an incredibly effective way to compare performance across different segments without needing multiple charts or filters.

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

Make it Interactive with Slicers

Static reports are a thing of the past. Add a Slicer visual from the Visualizations pane to your report. Drag a field like Sales Date into it. This creates an interactive filter that users can adjust to see the sales for a specific time period, and your clustered column chart will update in real-time. This user-driven exploration empowers your team to find their own answers.

Highlight What Matters with Conditional Formatting

Conditional formatting helps you draw a viewer’s attention to key data points by automatically changing a bar's color based on a rule you set. For example, you can make any revenue bar above $1,000,000 turn green while all others stay gray.

To set it up, go to Format your visual → Columns, and click the fx button next to the color selection. From there, you can define rules based on the chart's values to highlight your top performers or areas that need attention.

Common Pitfalls to Avoid

• Too Much Clutter: Avoid plotting dozens of categories on your X-axis or including 10+ items in your legend. This creates a "rainbow chart" that is impossible to read. If you have too many categories, consider grouping them or using a filter.
• Misleading Scale: By default, Power BI starts the Y-axis at zero, which is good practice. Be careful if you ever manually change it, as starting a bar chart from a different value can distort the comparison between bars.
• Unclear Labels: Always make sure your axis titles and chart title are clear. Your audience shouldn't have to guess what "Value by Cat1" means.

Final Thoughts

The clustered column chart is a fundamental and powerful visual in Power BI. You've now learned how to create one, format it so it's clear and compelling, and apply advanced techniques like small multiples and conditional formatting to surface deeper insights from your data.

Building charts in traditional BI tools is a valuable skill, but it often involves a lot of manual clicks for creating, styling, and refining each visual. Here at Graphed, we focus on helping you get from raw data to actionable insights in seconds. Instead of a series of clicks, you can simply connect your data sources (like Google Analytics, Shopify, or Salesforce) and use plain English to create dashboards. For example, you could type "Create a clustered column chart showing Shopify revenue by campaign, grouped by country for the last 90 days." Give Graphed a look and see how quickly you can get answers from your marketing and sales data.