Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Setting a dynamic Y-axis minimum

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.
 
 
Dashboards

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.