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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
HamidBee
Power Participant
Power Participant

How do I show the lines for the X and Y axis across a Line Chart?

Hi All,

 

How do I show the lines across the Y and the X axis for this Power BI line chart?

 

Line Chart.png

 

I am looking to create lines like the ones below:

produce_monthly.png

Thank you, 

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @HamidBee 

 

Unfortunately, this is by design. power BI is now unable to achieve what you need . You can submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

14 REPLIES 14
ManlioAl007
New Member

Yo lo resolví con líneas constantes para cada eje X y Y.Ejes X y Y.png

dg123456789
Advocate II
Advocate II

This should not be marked as solved as it is not solved. "PowerBI cannot do this" is not a solution. Please keep this unsolved until it's figured out.

DataGoalsDan
Advocate I
Advocate I

I know this is a bit old now but I just came across the same problem and figured out a work around.

 

You can make use of the 'Plot area background' image property.

 

Use snipping tool to take a snip of you chart and paste it into PowerPoint, then add lines exactly where you want them using PowerPoints insert shape option.

 

Now select the lines you have added using ctrl+click and then right click, 'Save as Picture...'

 

Then go back into Power BI and add that image as your Plot area Background image and set 'Image fit' to 'Fit'.

 

Worked out pretty well for me.

This is definitely useful to know. 

Anonymous
Not applicable

Thank you. To be honest, it is not a huge deal if I have the lines or not but I thought it would be nice to have them. I'm actually shocked that the Power BI team haven't included that as an option. You'd expect it to be there by default.

v-zhangti
Community Support
Community Support

Hi, @HamidBee 

 

Unfortunately, this is by design. power BI is now unable to achieve what you need . You can submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Burningsuit
Resident Rockstar
Resident Rockstar

Hi @HamidBee 

On the standard Line Chart, go to the format options, and on the Y-Axis you can edit the Gridlines (option right at the bottom) You can set the Color, Width and Style.

Burningsuit_0-1643107693332.png

Burningsuit_1-1643107843530.png

 

This sets the Y-Axis lines (horizontal), however there is no way to set X-Axis lines (vertical) with the standard line chart.

Hope this helps

Stuart

Hi, Thank you for your response. It's not the gridlines I'm looking for but the lines across the axis like the image below:

produce_monthly.png

 

 

amitchandak
Super User
Super User

@HamidBee ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi, I was just wondering if the image I shared provided some clarity. Thank you

produce_monthly.png

Hi, I'm referring to these black lines here.

 

anyone? pls share the above solution for all PBI standard chart 

Hi, 
I think you could re-consider what value these line add to your visual and if they are definitely needed. If business still requires them perhaps adding grindlines would be sufficient as suggested in earlier response.
Alternatively, you could look for a different visual altogether
e.g. this pulse visual provides something similar to what you're looking for

MargaritaG_0-1643205006549.png

or Craydec Control Charts

MargaritaG_1-1643205335349.png

 

Thank you. To be honest, it is not a huge deal if I have the lines or not but I thought it would be nice to have them. I'm actually shocked that the Power BI team haven't included that as an option. You'd expect it to be there by default.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.