Can I limit a dimension along on Y axis?

[sambrown]

Hi,

I'm creating a scatter plot where on the Y axis I have 'transfer value (£)' and on X I have the 'start date'. I want to limit the dimension where the transfer value '>0' (nice and easy). However, when I go to limit the dimension it says 'Calculated on Dimension: Start Date' and I have no option to change it to use the other measure.

If I swap the measures around, I can limit it by the transfer value but it makes the graph confusing to read.

My question is, can I put a limit on the transfer value while keeping it on the Y axis?

[OmarBenSalem · Accepted solution]

Change YourSecondMeasure:

from:

sum(YourSecondMeasure)

to:

if(sum(YourSecondMeasure)>0,sum(YourSecondMeasure))

[sambrown]

Always helps to have a fresh pair of eyes look at something! Thank you so much!