Dual Y-Axis Line Chart

September 11, 2019 By Mike Carlo

Ever need two different scales on the Y-Axis of a line chart? If so, then this tutorial is for you. While creating a dual y-axis line chart is pretty common in excel, it is not as easy in power BI. The only standard chart that comes with Power BI Desktop that enables dual y-axis is the Column and line combo chart types.

For this particular visual I needed to show correlation between two time series with different Y-axis scales. The Y-axis on the left of the chart had data elements in the thousands, but the right side needed percentages. The tutorial below illustrates how to accomplish by building a custom visual using the Charts.PowerBI.Tips tool.

Video Tutorial

note: there are a bunch of really good custom visuals that can be downloaded from the Microsoft App Source store. However, this article will not review all third party visuals that are able to produce a dual Y-axis line chart.

Source files

All files used to create this visual are located here on GitHub.

Layout file

The file used in this tutorial was a derivation of the Sunset layout from PowerBI.Tips. If you like this file, you can download it here:

Aug 13, 2026

Fabric as a Backend – Ep.554

Mike has been building apps on Fabric as a backend since January, and he's coining it FAB. The case isn't that you already own Fabric — it's that the workspace identity, git integration, and SQL database remove the wiring you'd otherwise do by hand in Azure.

Aug 11, 2026

Crawl, Walk, Run with AI in PBI – Ep.553

Meagan Longoria's five-stage maturity model for agentic Power BI development gives Mike and Tommy a framework to argue with. They mostly agree — except on the crawl stage, where Mike thinks starting with an MCP server beats starting with a chatbot.

Aug 6, 2026

Power BI Desktop Bridge – Ep.552

Desktop Bridge gives agents a local server to drive Power BI Desktop — reload files, check report state, and take screenshots so the agent can verify its own work. Mike and Tommy agree on the prerequisite: don't use it without skills.