PowerBI Stacked Column Chart with 2 Metrics Y - axis scaling issue

[DivyaN]

I have a requirement to add two measures in stacked column chart
where the isssue is that when we have two measures the y axis is been doubled for two measures
Example : Total Price  is 30M and  MTD Price is 15M and the Y- axis being added as 45M instead 30m where 15m is not been fitted into 30M.
where I should get the Yaxis like below Sample: 

where as in power BI we are getting like this

it makes the numbers misleading, Is there any workaround to overcome this.

[v-denglli-msft]

Thanks for the reply from @lbendlin  , please allow me to provide another insight.

Hi, @DivyaN ,

In a stacked column chart, on the Y-axis, multiple measures are stacked.

You might consider using another visual, such as a clustered column chart.
Display the two measures in two separate columns.

Best Regards,

Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

It works exactly as it should. You need to modify your second measure to reduce the value accordingly.