How to Add a Secondary Axis in Power Bi

214
How to Add a Secondary Axis in Power Bi

Here we can see, “How to Add a Secondary Axis in Power Bi”

One of the key aspects of Power BI Desktop is the ability to create charts, but many customers are having trouble producing the Y-axis (secondary axis).

On the official Power BI forum, one user mentioned the following:

Currently using Power BI Desktop (just downloaded last week). I’m trying to create chart with secondary axis (Y-axis). However, in the tool, when I select from Visualization pane, ‘Y-Axis’ then ‘Show secondary’, nothing happens. In the video, I see that underneath that option when it is selected, there are other options to select like position it on ‘right’ side.

As a result, using the standard approach to build a chart with a secondary axis (the chart’s vertical axis) has no effect. Fortunately, there is a relatively simple fix for the problem.

Also See:  Amazon taps Affirm to offer a new installment purchase option for buyers

Steps to add a secondary axis in Power BI

Add a metric to the line values

You just need to add a metric to the line values to easily address the problem.

    1. Simply select Favorite Count.
    2. Choose the preferred metric for your axis.

Conclusion

I hope you found this guide useful. If you’ve got any questions or comments, don’t hesitate to use the shape below.

User Questions

1. In Power BI, how can I create a secondary axis?

Click the Format button (the paint roller icon) to view all the formatting possibilities for your secondary axis. Then, select the Y-axis option next. Y-Axis (Column) and Y-Axis are the two options you will find for your y-axis (Line). The screenshots compare the various choices side by side.

2. How do you layer two graphs on top of one another in Excel?

To pick both charts at once, click the second chart while holding down the “Ctrl” key. Next, click the “Page Layout” tab, and then under the ribbon’s Arrange section, click the “Group” button. Both charts will have a big box around them.

3. Two Y axes are they possible?

A second Y axis is a Y axis that is depicted on a chart’s right side. It may display a different scale or the same axis scale as the main Y axis. On a large chart, you can add a second Y axis with the same scale as the main Y axis to make it simpler for viewers to understand the data.

Also See:  How to Sell Books on Amazon

4. How to create a secondary axis with a line graph that … – Reddit

How to create a secondary axis with a line graph that has a legend from PowerBI

5. Bar chart with two Y axis? : r/PowerBI – Reddit

Bar chart with two Y axis? from PowerBI