Line y-axis unable to display dynamic constant measure

[Jeffrey2]

My goal is to see how each group performs compared to a specific standard. I am trying to display a constant line in the Line y-axis of a chart. If I put an actual number in the measure (e.g. Metric = 5), I can produce a constant line across all dates:

However, I want to make the Line y-axis dynamic. For example, if I choose group 1 in a slicer, the metric would be 5, but if I choose group 2, the metric would be 3. When I attempt this, the visual produces the line y-axis bar ONLY if bars appear (data in the Column y-axis):

Is there a way to make the line appear even if there is no data present in the bar chart data?

[MFelix]

Hi @Jeffrey2 ,

How are you adding the Constant line are you using a Column and line chart?

i don't know what is the calculation you want to achieve but I have added a simple measure that is the average of  the values.

Then I added this measure yo the reference line and the result is below:

[Jeffrey2]

I'm using the Line and Stacked column chart. With that visual I do not see a "reference line" option. What visual are you using?

[MFelix · Accepted solution]

Hi @Jeffrey2 ,

I'm using the column chart, but I also see it available in the line and column stacked chart.

You just need to click on the + Add Line

[Jeffrey2]

Thank you for the help. I've never used that button!