Using Min and Max measures on Y axis start and end - how to make dynamically change like graph does

[JamesLindsay101]

Hi everyone, I'm currently trying to tidy up my axis on my graph, as the range is way too big and is meaning I'm not seeing any real change. please see below the picture, the green one and the left axis is the axis of concern.

My aim is to get something like the green line and left axis, that will dynamically change when certain departments are filtered. (For the below I just manually input numbers to show my aim).

I'm working with an employee listing table (each row shows a single employee with their start date, and end date if they have one)

Then also a date dimension table.

I did try building in a min and max headcount measure, please see below the measure below for max (min is similar but opposite). 

Max Headcount = MAX('Date Dimension'[Current Headcount])*1.1

where current hadcount is:

Current Headcount = CALCULATE(DISTINCTCOUNT('Employee Listing'[Employee Number]),FILTER('Employee Listing','Employee Listing'[Start Date]<='Date Dimension'[Date] && ('Employee Listing'[Termination Date]+1>'Date Dimension'[Date]||ISBLANK('Employee Listing'[Termination Date]))))

When I input these into the start and end formula of the Y axis, the max is in the 2000's, and the min is in the 60's (a large range than the auto range), so they may need changing in some way.

My thinking is could I put a filter on my max and min measures somehow to match what's in the graph?

Thanks in advance for your help!

[Anonymous]

Hi @JamesLindsay101 ,

Please provide sample data in a tabular style and show your expected results.

Best regards,
Community Support Team_ Scott Chang