April 6, 2020

Create Dual Y-Axis Line Chart in Power BI

Overview:
In this blog, we will learn how we can create a Native Line chart with dual Y-Axis in Power BI. Sometimes, there are situations where we need to represent two Y-axis in the line chart. Earlier Dual Y-Axis feature was not available in Power BI but it got released with March 2020 - Power BI Updates.

Example:
We want to represent Actual and Budget Sales with the # of units sold in the line chart. We need to represent this with two Y-Axis.
  • One which represents Sales Data
  • The second which represents # of Units
Now, let’s get started!

Step 1: Add a Line chart from the visualization pane.

Step 2: If you carefully observe, we can see the Y2 Axis in the format section.

Drag Sales fields to Values section and Units to Y2 Axis.

Step 3: The Dual Y-Axis line chart will look like this.

Also, we can format the Y2 Axis using the following option.

Conclusion:
This is how we can easily create Dual Y-Axis line chart in Power BI. Happy Reporting!

If you have any questions you can reach out our SharePoint Consulting team here.

No comments:

Post a Comment