Overlapping bar chart with multiple axis in PowerB

问题:

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:

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

Thanks in advance,

回答1:

Multiple axes? Yes! Overlapping bars? No!

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

---

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:

2. Click Line and Clustered Column Chart under Visualizations

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

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

5. Under Y axis, set Show Secondary to On

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.

回答2:

It's certainly not an ideal solution, but it is possible to place charts on top of each other. This is the result of two bar charts superimposed upon each other:

Note: In order to have control over the column width, you need to change the x-axis to categorical and adjust the inner padding.