Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

2 Y axis - columns to have no spaces


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?


Super User
Super User

@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])

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

& yes Year is # 

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors