Search code examples
data-visualizationpowerbipowerbi-desktop

Overlapping bar chart with multiple axis in PowerBi

I would like to have a overlapping bar chart in PowerBi with multiple axis. I have an example from Excel which I would prefer to recreate in PowerBi if this is possible.

Here the example:

Preferred Graph

Is this possible in PowerBi? Maybe by using a custom visual I don't know off.

Thanks in advance,

Solution

  • Multiple axes? Yes! Overlapping bars? No!

    Using a Line and Clustered Column Chart is the way to go:

    enter image description here

    Here's a demo using some random numbers:

    Date        A           B           C
07.08.2018  0,359008828 0,993689927 0,8
08.08.2018  0,127630228 0,449164386 0,8
09.08.2018  0,431825126 0,615830289 0,8
10.08.2018  0,269830973 0,984995499 0,8
11.08.2018  0,27416548  0,64248379  0,8
12.08.2018  0,777712123 0,740108131 0,8
13.08.2018  0,264229043 0,242084953 0,8
14.08.2018  0,49124239  0,144428206 0,8
15.08.2018  0,242050334 0,020032871 0,8
16.08.2018  0,316102617 0,644935538 0,8
    1. Use Enter Data to get a table with these numbers under Fields:

    enter image description here

    1. Click Line and Clustered Column Chart under Visualizations

    enter image description here

    1. Drag Date to Shared Axis, and change the date hierarchy to simple date using the drop down menu next to Date.

    enter image description here

    1. Drag C to Line Values, and A and B to Column values:

    enter image description here

    1. Under Y axis, set Show Secondary to On

    enter image description here

    And that's as close as you're going to get to replicate your Excel Chart at the time being as far as I know.