How to use Y-axis custom range

[su_pyae]

Hello everyone, 

I am trying to figure out how to use custom range for Y-axis. They have 3 options: Min, Max, and Min/Max. 

I have several measures and I want to have more range than the actual min and max of my data. 

As can be seen from the following screenshot, (+100) should be on the top of the block, not in the block. 

By adding a little bit more range to my min(measures) and max(measures), I am thinking I should be able to avoid these kind of situations. 

Thank you for your help in advance. 

[anthonyj]

Hi @su_pyae ,

You can add height to your Y axis by choosing the Max option in the custom properties. In the function you can add the calculations you've added in the waterfall chart to ascertain the height and then multiply by (for example) 1*2. You can play with the multiplication to get the height you're looking for.

From the look of your chart you could get away with adding just the first 2 measures in your calculation but in some instances you might need to include more. (Additions and subtractions)

For example:

(sum(Measure1) + sum(Measure2) ) * 1.2

Regards

Anthony