Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
For example, the graph above has only four gridlines, how can I increase this?
Thank you
Solved! Go to Solution.
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.
2. Select "Y-Axis Constant Line".
3. Select "Add line".
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!
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.
2. Select "Y-Axis Constant Line".
3. Select "Add line".
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!
you can play with the min and max of the y-axis
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:
Do you know how to do this? Thank you.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
67 | |
65 | |
56 | |
39 | |
27 |
User | Count |
---|---|
85 | |
59 | |
45 | |
43 | |
38 |