Idea is that when I select an integer parameter option as 'None' I want another integer parameter that shows whether Y axis should include /exclude 0 to 'exclude 0' basically removing the zero line. How can I achieve this.

@garima gulati​ 

Hi, to acomplish this:

a. You would need to create a boolean parameter. Let's Call it [Show Zero].

b. After that, you can create a field [Ref Line]:

IF [Show Zero] THEN 0 END

c. Drag this field to Detail in your Mark Shelf.

d. Then create a reference Line at Table Level that uses the Field [Ref Line], Remove the label, and the color:

e. Finally, exclude the zero from the axis.

Attached a workbook for your reference.

I hope it works for you. 🙂 

If this post resolves the question "Select as Best" or if it assists in resolving the question, please "Upvote". This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

Regards,

Diego