line and stacked column chart 2nd y-axis

[PBIMike]

Hello,

I'm using a line and stacked column chart. The 2nd y-axis on the right represents my line graph scale. The formatting option for this chart type only allows you to amend the x-axis and y-axis - how can I amend the 2nd y-axis?

I am just looking to set the 'start' point of this 2nd scale as 0.

If this cannot be directly formatted, is it possible to add a hidden 0 field for one of the months in my chart to force the scale down? If for example, I included Dec-18 with a 0 value, could I use this to force the 2nd y-axis to 0, but hide the Dec-18 data on the chart?

Many thanks,

Mike

[amitchandak]

@PBIMike , In Visualization format you have Start and End option for axis.

[PBIMike · Accepted solution]

Argh, I realised that even though my 2nd y-axis is working and visible, you have to scroll down the y-axis options and select 'show secondary', which then opens up the relevant formatting options 🙂