Skip to main content

    Power BI

    Needs Votes

    Multiple Y-Axis on a chart

    Vote (2057) Share
    Rik Opdam's profile image

    Rik Opdam on 24 Feb 2015 19:11:35

    We would like to have multiple y-axis on a chart, more than 2

    Administrator on 20 Aug 2020 01:24:04

    Multiple y-axis for Cartesian charts is on our backlog. I don't have a timeline to share, but please keep voting. I'll update the idea once we have more information to share.

    Comments (213)
    Rik Opdam's profile image Profile Picture

    223102fb dfb1-4094-b38f-ec3e2b47f2b0 on 16 Aug 2020 03:53:01

    RE: Multiple Y-Axis on a chart

    I only need to have two y-axis. If this is added, I would also like to be able to set properties for each axis separately.

    Rik Opdam's profile image Profile Picture

    3466fc43 e3d5-4f0c-8e3b-8c9f6328ce9d on 16 Aug 2020 03:52:54

    RE: Multiple Y-Axis on a chart

    I would amend this - any chart type that has an X or Y axis should allow a secondary axis. Which axis a measure appears on is simply an attribute of the measure, not a new visualization type. You should be able to click on the measure in Values, and there should be an option to show on secondary axis. Obviously, this would not be an option for a non-cartesian viz like a pie or treemap, but anything with an X or Y axis should allow for it.

    Rik Opdam's profile image Profile Picture

    20023664 229c-4a76-a38d-5bff76d691c5 on 16 Aug 2020 03:52:24

    RE: Multiple Y-Axis on a chart

    I have four y-values: average, max, min, count. Ideally all four are presented by a bar, but with a different y dimension.

    Rik Opdam's profile image Profile Picture

    526b6860 8c4e-44f1-a272-39c32a13fb70 on 16 Aug 2020 03:52:24

    RE: Multiple Y-Axis on a chart

    Add secondary axis to Line charts as new visuals, now only exists on the Line and Stacked column chart
    Also two Y axes on the basic line chart

    Rik Opdam's profile image Profile Picture

    cd654e36 ce81-4354-a381-7b3710da6fdf on 16 Aug 2020 03:52:21

    RE: Multiple Y-Axis on a chart

    Very important for many studies e.g. studies by Tier or Term for Automotive financing

    Rik Opdam's profile image Profile Picture

    c6366888 1c5c-4202-a0b9-2603ef2f0534 on 16 Aug 2020 03:52:04

    RE: Multiple Y-Axis on a chart

    It would be very usefull for comparing Scenarios: e.g. Actual - Plan/Previous years

    (http://www.ixto.de/blog/wp-content/uploads/091.png)

    Rik Opdam's profile image Profile Picture

    77a84312 0efa-4adf-8549-dfdb2f5a92d8 on 16 Aug 2020 03:52:00

    RE: Multiple Y-Axis on a chart

    Can do this in Excel - why not PowerBI? Multiple Categories on Axis would be very useful, or else we would have to look at another vendor.

    Rik Opdam's profile image Profile Picture

    2c9aa7f6 4ef5-4274-bf50-89cc4c01c964 on 16 Aug 2020 03:52:00

    RE: Multiple Y-Axis on a chart

    I agree with everyone here. I need at least one more axis so I can plot a percentage across usage values

    Rik Opdam's profile image Profile Picture

    0af68b0e 6c8b-4462-8fac-8510031e3290 on 16 Aug 2020 03:51:48

    RE: Multiple Y-Axis on a chart

    Hope this request includes on Charts (Line, Bar, Area) atleast?

    Rik Opdam's profile image Profile Picture

    30df1caf ee1f-4b59-92ef-6d0bf05b257e on 16 Aug 2020 03:51:46

    RE: Multiple Y-Axis on a chart

    Yes, please add multiple (at least 2) Y-axis to charts. Needed for deeper analysis. Also competitors have this so must-have for PBI.