line and clustered column chart - line to short

[SIH007_1]

Hi, I have the following issue: my columns show the actual values, the line should show the goal. The goal is a measure, the value is fix depending on the filter set (Filter =1 ==> Goal 4, Filter = 2 ==>Goal 7...)

So what I want is a horizontal line going from left to right, or at least over the width of the columns + distance. 

But the line is always to short, if I have more columns it appears over maybe 50% of the left and right column, if I have only 2 columns it looks like this. How can I fix this issue?

[v-yetao1-msft]

Hi @SIH007_1 

Are you trying to change this to a straight line ? If yes , just change the style to solid in visual formatting .

Best Regards,
Community Support Team _ Ailsa Tao