Forum Discussion

Danfountain's avatar
Danfountain
Helper I
2 years ago
Solved

Calculating the Y Axis maximum

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
Need Help
  • Danfountain's avatar
    Danfountain
    2 years ago

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

2 Replies

  • Danfountain's avatar
    Danfountain
    Helper I
    2 years ago

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

  • Danfountain's avatar
    Danfountain
    Helper I
    2 years ago

    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 🙂