Skip to main content
cancel
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

Reply
grayv
New Member

2 Y axis - columns to have no spaces

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

 

grayv_0-1708331497701.png

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

 

columns layer are greyed out

grayv_0-1708331747562.png

 

any ideas how I can achieve my chart?

 

2 REPLIES 2
amitchandak
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.

 

amitchandak_0-1708336057422.png

 

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

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

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