CODEWITHSUNDEEP
data-visualizationpowerbipowerbi-desktop
Dennis vd Eijnde
Dennis vd Eijnde

Reputation: 303

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,

Upvotes: 2

Views: 25980

Answers (3)

Asit M
Asit M

Reputation: 101

There are multiple custom visuals available on the appsource now. Search for lipstick charts. see screenshot below. one of those is here

https://appsource.microsoft.com/en-US/product/power-bi-visuals/yavdaanalyticspvtltd1628223732998.lipstickcolumnpro?tab=Overview

microsoft power bi appsource lipstick column pbivizedit

Upvotes: -1

vestland
vestland

Reputation: 61104

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.

Upvotes: 4

Alexis Olson
Alexis Olson

Reputation: 40204

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:

Double Chart

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

Upvotes: 4

Related Questions