How to align the axis max value on a line and stacked combo chart

[Majad_Chowdhury]

Hi,

I have a line and stacked column combo visual on power bi. Ideally I would want just 1 axis however it doesnt seem to be an option as I have selected values in both the y axis

Therefore i have 2 y axis, however they both have different min/max. I cant fix it as I need it to by dynamic as filters are applied often to the visual which can drastically decrease the max required.

Is there anyway i can use a formula of some kind to make the max of both the first and second y axis to always be equal to the max value currently being presented on the visual.

This is the visual i have at the moment:

Please note that the left y axis has a max of 2000 whereas the right y axis has around 1700. How can I sync these without losing the functionality of having an auto dynamic axis which changes with the filters

[BITomS · Accepted solution]

Hi @Majad_Chowdhury ,

Your assertion of creating a formula is in the right direction. I think if you create a measure to evaluate the MAX of both of your Y-Axis measures (taking the higher value) and then use this within the Maximum formula for both the Y-Axis and Secondary Y-Axis, this should dynamically align the upper bound of your visual.

The new measure = IF(MAX('FirstMeasure)>MAX('SecondMeasure),MAX('FirstMeasure'),MAX('SecondMeasure'))

I think multiplying the above by 1.1 may be even more suitable so it gives you a 10% buffer and your visual bars/lines do not go right to the edge of the chart.

Then add this to the following:

Hope this helps!