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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
alpha-san
Frequent Visitor

How to add additional horizontal gridlines on a graph?

Hello, how can I change the number of horizontal gridlines on a graph? I want to be able to add more gridlines to my graph.

 

alphasan_1-1705958159214.png

 

For example, the graph above has only four gridlines, how can I increase this?

 

Thank you

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @alpha-san ,

 

Hope all is going well.

 

In order to solve your problem, I did many tests and then found the solution to your problem, it is so convenient.

 

Please follow these steps:

 

1. Select the Visualizations tab on the right.

vhuijieymsft_0-1705987079778.png

 

2. Select "Y-Axis Constant Line".

vhuijieymsft_1-1705987104325.png

 

3. Select "Add line".

vhuijieymsft_2-1705987116451.png

 

 

In this function, you can add as many horizontal grid lines as you want.

 

Where "Value" represents the value at which you want to add horizontal grid lines. "Color" represents the color of the horizontal grid lines. "Transparency" represents the transparency of horizontal grid lines. "Style" indicates the style of horizontal grid lines, including Dashed, Solid, and Dotted. "Data label" indicates whether the data points of the current horizontal grid line are displayed next to the horizontal grid line.

 

Should you have any questions or concerns, please do feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Hi @alpha-san ,

 

Hope all is going well.

 

In order to solve your problem, I did many tests and then found the solution to your problem, it is so convenient.

 

Please follow these steps:

 

1. Select the Visualizations tab on the right.

vhuijieymsft_0-1705987079778.png

 

2. Select "Y-Axis Constant Line".

vhuijieymsft_1-1705987104325.png

 

3. Select "Add line".

vhuijieymsft_2-1705987116451.png

 

 

In this function, you can add as many horizontal grid lines as you want.

 

Where "Value" represents the value at which you want to add horizontal grid lines. "Color" represents the color of the horizontal grid lines. "Transparency" represents the transparency of horizontal grid lines. "Style" indicates the style of horizontal grid lines, including Dashed, Solid, and Dotted. "Data label" indicates whether the data points of the current horizontal grid line are displayed next to the horizontal grid line.

 

Should you have any questions or concerns, please do feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Thank you so much for your response!

Daniel29195
Super User
Super User

@alpha-san 

you can play with the min and max of the y-axis 

Daniel29195_0-1705963046755.png

 

Daniel29195_1-1705963058666.png

 

 

 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

Hello, thanks for your response. Sorry my post wasn't very clear. I was trying to figure out how to add additional gridlines by adding more y-axis labels. Like this:

alphasan_0-1705978831903.png

Do you know how to do this? Thank you.

@alpha-san 

refer to @Anonymous  solution . 

this should do the trick

 

 

 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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