I am trying to add a reference line - budget line - in the visualization. However, our performance is not meeting the budget - the highest value we have achieved is a 134. The budget line is 135. Currently the chart only shows the maximum value of 134 - thus the budget (reference line) is not show.
If I add a max area to the chart of 136, it shows up - however, that leads to other problems (not dynamic). If the next day we go over 136, it would not show up. If I change the max to something like 200, the scaling of the chart is off.
Is there a way to ensure the reference line is plotted on the chart, even if the maximum underlying data is below it without forcing the scale max?