How to align the vertical axis in the combined stacked-column and inline chart

[CarlosOlmos29]

Hello Power Bi Community!

I would like to show a Stacked column and line charts where the y axis and the secundary y axis have the same scale when I apply a filter. I already applied a trick, setting the same data at both axis, but it doesn't work perfectly in some cases, as it can see in the picture below.

I hope I have made myself clear. Thanks in advance for your help.

[v-zhangti · Accepted solution]

Hi, @CarlosOlmos29 

I simulated some data, hoping to match your situation, and you mainly look at the Y-axis setting range.

MeasureA = CALCULATE(SUM('Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[Date]),[Type]="A"))

MeasureB = CALCULATE(SUM('Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[Date]),[Type]="B"))

     

Result:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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