Monthly Target in Line Chart

[BigKev]

Hi All,
I have encountered some issues in displaying Target as a monthly line chart.

At the moment, this is what my data looks like

D1, D2, and Target are displayed as monthly bar charts. (D2 are mostly blank for each month; hence, there is a gap in between the bar chart for each month)

I want to show the Target as a Line chart for each month (Each month has a different target).
When I use the ‘Line and Cluster column chart’ visual and move the target to the Line y-axis, it looks like this.

However, I want the target line to look like this for each month (red arrow)

How can I achieve this?

Thanks,

Kev

[danextian · Accepted solution]

Hi @BigKev 

You can reduce the line width to zero and use markers. The marker closest to what you want is either a short or a long dash.