2 Y axis - columns to have no spaces

[grayv]

Hi

wow my first question!  

I have a 2 axis chart:  but I want the columns on the 1st axis to be a completely filled space - ie all blue on one side and all green on the other - no visible space inbetween the columns.

Here is my chart - so the blue represents population actuals, and the green represents predicted values 

I used a measure of 1 to build the 1st column axis and the population rate as the 2nd line axis

the measure of 1 is coloured with the record 'type' to show actual v predicted

But I would rather just shade the columns to look like a 'background' on the chart 

columns layer are greyed out

any ideas how I can achieve my chart?

[amitchandak]

@grayv , Hope year's data type is number, the you can add X-axis Constant reference lines. (Reference line in format or old analytics pane) . Post that you can have line based on measure using Fx, I used static value.

measure you need  for constant line

Maxx(filter( values(Date[Year]), not(isblank([Actual])) ), [Year])

[grayv]

thanks for that ill give it a go and let you know 😊

& yes Year is #