Calculating the Y Axis maximum

[Danfountain]

Hi all,

So I have a line and stacked column chart.  I need the Line, and the stacked column to work on the same axis.  However that doesnt seem to be possible if using the auto range......

So my chart has months on the X axis (commonly the last 12).  The main column measure is a simple one of:

Measure_Count = COUNT(Facttable[Key])

The line on the secondary Y measure is this

Measure_Count_LastPeriod = CALCULATE(Facttable[Measure_Count ], SAMEPERIODLASTYEAR('CalendarTable'[Date]))

So I now need to find a way to bring back the maximum for any given periods over the chart based on either of these so i can set that as the maximum.

Any ideas how i would do that as i am struggling.  Either that or any other way to keep my Y axis and secondary Y axis in sync.

Thanks in Advance.

Dan

[Danfountain]

For anyone interested its because i had the zoom slider turned on.  If you either display the secondary axis or turn on the zoom slider then it doesnt keep them in sync.  If you leave them both off then it stays in sync 🙂

[Danfountain · Accepted solution]

Please ignore this thread.  I think i have gone down an odd rabbit hole.