Setting a dynamic Y-axis minimum

[Anonymous]

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.

[Anonymous]

Hi @Anonymous ,

May not have fully understood what you meant. Since 0 multiplied by any number is 0, you could write an addition operation, or you could write an IF statement to try it.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.