A reference line is a useful worksheet element. It’s a simple tool - just a line based on a single value that we want to reference in our views.

But, did you know that you can change the value of a reference line using a parameter?

An adjustable reference line turns your static reference line into an interactive tool that you and the end-users of your dashboards can use in a variety of ways. You might run basic forecasts, explore outcomes using 'what if" scenarios, or change a comparison threshold.