Dual Bar and Line graph to two y-axis

[Cma2]

Hi,

How can I create the below chart into powerBI? This is a dual bar graph where it shows target goals as the two lines. So in this case, the deep blue bar and the red line corresponds to the left y-axis. Meanwhile the purple bar and the lighter blue line corresponds to the right y-axis.

 

I've gotten something similar in power BI, but the "bars' and the "lines" both corresponding to only one axis (ie bar only to left axis and line to right axis) and I can't get same data. Please note that the chart has to look these way due to some business reason.

Edit: Just to add, I have to exact same datain powerBI. I can put the data into the chart, but I just can't make it look the same way.

[v-easonf-msft]

Hi, @Cma2 

As of now, the visualization that comes with powerbi cannot meet your needs.

I would suggest you  try to  get more visuals in 'AppSource'.

You can also  post your idea and add your comments  on Power BI Ideas forum to make this feature coming sooner. 

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Cma2 , enable secondary axis on Clustered bar and line visual, That will give all lines on the secondary axis.

refer: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

[Cma2]

Hi,

I've done so, however like I said previously... The problem with that is both of the bars scales to the right y-axis and both of the line scales to the left axis. I need to be able to customize which line corresponds to which axis, for example I need blue bar and red line correspond to the right y-axis, and purple bar/light blue line correspond to the left y-axis.