Greetings,
I have several line and clustered column charts.
X-axis = year and monthnumber
Y=axis column average cost per stop included corrections
DAX:
DIVIDE([total costs], [Total stops])
Y=axis line average cost per stop excluded corrections
DAX:
CALCULATE(DIVIDE([Total costs], [Total stops]), Network[Network] <> "COR")
On the page is a pagefilter that shows the last 11 calendar months
Each chart has a filter for a specific depot
on the dashboard is a slicer where you can select different networks
The problem i'm having is the start of the Y-axis. With auto it starts at $0 but when the line is close to the column you can't really see the delta. If i set a specific value it might be to high or to low when switching in the slicer.
I wanted to link the minimun to a DAX that calculates 90% of the minimum vallue in the chart and that switches when selecting a different option in the slicer.
I tried DIVIDE([total costs], [Total stops]) * 0.9 but ofcourse that was to easy to think of and doesn't work. I can't figure it out. Please help.
