What is a Secondary Y Axis in Power BI?

Trying to show two different types of data on one Power BI chart can feel like a headache, especially when one set of numbers is in the millions and the other is a tiny percentage. Thankfully, there’s a simple solution built for this exact problem: the secondary Y-axis. This article will walk you through what a secondary Y-axis is, when you should (and shouldn’t) use it, and exactly how to add one to your Power BI reports.

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 Exactly is a Secondary Y-Axis?

A secondary Y-axis, also known as a dual axis, is a second vertical axis on the right-hand side of a chart. The primary Y-axis sits on the left, as it normally would. You use this secondary axis to accurately display two data series that have different scales or units of measurement on the same visual.

Imagine you want to track your monthly sales revenue (e.g., $150,000) and your conversion rate (e.g., 2.5%) on the same graph to see how they relate. If you plot them both on a single Y-axis, your multi-thousand dollar revenue numbers will form a nice bar chart, but the conversion rate will look like a completely flat line somewhere near zero. The scale is just too different for both to be meaningful on one axis.

By adding a secondary Y-axis, you give the conversion rate its own scale on the right side of the chart. Now, the revenue is measured against the left axis (from $0 to $200,000), while the conversion rate is measured against the right axis (from 0% to 5%). Suddenly, you can clearly see the distinct trends of both metrics in one cohesive view and analyze their relationship over time.

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

When Should You Use a Secondary Y-Axis?

Adding a second axis is powerful, but it's not a silver bullet for every reporting need. Using it incorrectly can make your chart confusing or, even worse, misleading. Here are the best times to use one and some important warnings.

Best Use Cases for a Secondary Y-Axis

• Comparing Data with Different Scales: This is the most common use case. It’s perfect when one metric is in the thousands or millions and the other is a much smaller number. For example: Marketing Spend ($) vs. Number of Leads (e.g., 500, 1200).
• Comparing Data with Different Units: You can effectively visualize two metrics that are measured differently. For instance, comparing total website traffic (a number) with the average session duration (in seconds) or the bounce rate (a percentage).
• Showing a Direct Relationship or Correlation: A dual-axis chart is excellent for highlighting how two metrics influence each other. A great example is plotting Revenue ($) and Units Sold. One is currency, one is a count, but seeing them together shows how volume translates to dollar sales.

When to Avoid a Secondary Y-Axis

While useful, dual-axis charts can be tricky because our brains instinctively compare the positions and heights of lines and bars, regardless of the axes. If the relationship isn't absolutely clear, you risk confusing your audience.

Ask yourself: Is the relationship between these two metrics direct and something my team needs to see in a single view? If not, consider these alternatives:

• Two Separate Charts: Place two standard charts side-by-side. This keeps each metric on its own clear, unambiguous scale and still allows for easy visual comparison.
• KPI Cards: Use KPI cards or simple gauges above a main chart to show the key figures (like the overall Conversion Rate %), while the chart below focuses on the primary trend (like Revenue over time).
• Small Multiples: The small multiples feature in Power BI can create mini-charts for a different category, which can sometimes be a clearer way to compare rather than layering them onto one visual.

A good rule of thumb: Use a secondary Y-axis when you need to clearly show the interaction between two related metrics with different scales. If you simply need to show two unrelated metrics, separate charts are often the better, clearer choice.

How to Add a Secondary Y-Axis in Power BI: A Step-by-Step Guide

The easiest way to add a secondary Y-axis in Power BI is by using one of the "combo" charts, such as the Line and stacked column chart or the Line and clustered column chart. These visual types are specifically designed for this purpose.

Let's walk through an example using the Line and stacked column chart. We'll plot monthly Sales Revenue as columns and Gross Margin Percentage as a line.

Step 1: Choose the Right Visual

In your Power BI report canvas, go to the Visualizations pane and select the icon for the "Line and stacked column chart." This will add a blank visual placeholder onto 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

Step 2: Add Your Data Fields

With the new blank visual selected, look at the field wells in the Visualizations pane. Now, drag and drop your data fields into the correct buckets:

• X-axis: Drag your shared dimension here. This is usually a time-based field like Date, Month, or Year.
• Column y-axis: Drag your primary, large-scale metric here. In our example, this would be Sales Revenue.
• Line y-axis: Drag the metric you want to plot against the secondary axis here. For us, this is the Gross Margin %.

At this point, you'll see a chart with columns for revenue and a line for the margin percentage. But because the revenue scale is so large, the margin % line will likely appear almost perfectly flat and close to zero - this is the exact problem we're here to solve!

Step 3: Enable the Secondary Y-Axis

This is where the magic happens. Here’s how you activate the second axis to give your line chart its proper scale.

1. Click on your visual to make sure it's selected.
2. Go to the Format your visual icon in the Visualizations pane (it looks like a paintbrush).
3. Expand the Y-axis section in the list of formatting options.
4. Inside the Y-axis settings, scroll down until you see the sub-section called Secondary y-axis.
5. Toggle the switch to On.

Instantly, a new axis will appear on the right side of your chart, scaled specifically for the data in your "Line y-axis" field (in our case, Gross Margin %). Your line chart will rescale against this new axis, making its trend clear and easy to analyze alongside the revenue columns.

Best Practices for Creating Clear Secondary Axis Charts

Now that you know how to build the chart, follow these simple tips to ensure it's easy to read and understand.

1. Use Clear, Descriptive Labels

Don't make your audience guess what each axis represents. Clearly label both. Go to Format your visual → Y-axis and find the Title settings for both the primary and secondary axes. Turn the titles on and name them explicitly, including the unit. For example:

• Primary Y-axis Title: Total Revenue ($)
• Secondary Y-axis Title: Gross Margin (%)

2. Be Smart with Color Coding

Color is your best friend when it comes to guiding your viewers' eyes. Make sure the color of the data series matches its corresponding axis.

• Go to Format your visual → Lines to set the color for your line chart.
• Go to Format your visual → Columns to set the color for your bars.
• To match the axis label color, head to the Y-axis section for both the primary and secondary axes, find the Values subsection, and choose a matching Color for the axis labels.

Consistency here is key. If your Gross Margin line is orange, make the "Gross Margin (%)" axis label on the right orange, too.

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

3. Don't Add Too Much Data

A dual-axis chart with one set of columns and one line is usually effective. Resist the temptation to add another line or more columns. The more you layer on, the more cluttered and confusing your visual becomes. Keep it simple and focused on telling one clear comparative story.

4. Keep the Context in Mind

Always ask yourself: what am I trying to show? Is it how our marketing promotions are impacting product-level sales? Or how operational costs relate to the overall profit margin? A secondary Y-axis should serve that story by clarifying a relationship, not obscure it by throwing too much information at the viewer.

Final Thoughts

The secondary Y-axis is a fantastic tool in your Power BI arsenal, especially for telling stories that involve comparing metrics of different scales or units, like revenue versus conversion rates. When used with care and supported by clear labeling and good design, it can reveal powerful insights in a single, compact visualization.

Getting your data telling these stories in tools like Power BI often involves navigating countless menus, field wells, and formatting options just to get one chart right. At Graphed, we've focused on eliminating that friction. We built an AI data analyst that lets you connect your data sources - like Shopify, Google Analytics, or Salesforce - and then simply describe the chart you want in plain English. For instance, you could just ask, "Create a dashboard showing our total revenue and conversion rate by month," and watch as Graphed builds the real-time visual for you in seconds, handling all the technical setup in the background. Get started for free with Graphed and turn your data questions into clear answers, instantly.