How to add a secondary axis in Power BI [EASY STEPS]

January 2023 · 2 minute read
power bi add secondary axis

XINSTALL BY CLICKING THE DOWNLOAD FILE

To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:
  • Download DriverFix (verified download file).
  • Click Start Scan to find all problematic drivers.
  • Click Update Drivers to get new versions and avoid system malfunctionings.

    • Creating charts in Power BI Desktop is one of the main features of this tool, but quite a few users are encountering issues in creating the Y-axis (secondary axis).

    One user reported the following on the official Power BI forum:

    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.

    So, when trying to create a chart with a secondary axis (the vertical axis of the chart) through the usual method, nothing happens. Fortunately, the issue has a very easy solution.

    Steps to add a secondary axis in Power BI

    Add a metric to the line values

    To solve the issue quickly, you simply add a metric to the line values.

    power bi line values metric

  • Click on Favorite Count.
  • Select the metric you prefer for your axis.

    • Conclusion

    So, that’s about it. Adding a metric to Y-axis will allow you to create a chart with a secondary axis.

    Leave your answer along with any other questions in the comments section below.

    RELATED STORIES YOU NEED TO CHECK OUT:

    ncG1vNJzZmivmaOxsMPSq5ypp6Kpe6S7zGiYnZxdqLKku82dmKuxXZbFqr%2BMqaawnaJir6p7