cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

how to change grid line number of intervals

Is it possible to control the number of intervals (or interval range) for grid lines in a line and stacked column chart?  For example, my chart's y-axis runs from 0 % to 100 %.  Power BI auto-calculates a grid line interval spacing of 20 percentage points (i.e., 0 %, 20 %, 40 %, 60 %, 80 %, 100 %).  I want the spacing to instead be 10 percentage points (i.e., 0 %, 10 %, 20 %, 30 %, etc.).

1 ACCEPTED SOLUTION
fhill
Resident Rockstar
Resident Rockstar

Sadly, this ability has been requested for years, but hasn't made it into Power BI yet.  I've seen some complciated work-arounds where people calcualte the resulting Line Chart Value Every X (5,10,15) units, to basically fake the ability with a Categorial Axis Type (this only works in very specific situations).

 

Please add your vote to these two requests to try to get movement on the idea:

https://ideas.powerbi.com/ideas/idea/?ideaid=6ba30ae6-6243-456a-9743-64441ddd7644

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17297545-add-the-axis-interval-in...

 




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




View solution in original post

2 REPLIES 2
gamos
Frequent Visitor

2023 update: as per @fhill suggestion above, vote for the idea that currently has the most votes (1418 votes so far for the link below).

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17297545-add-the-axis-interval-in...

 

fhill
Resident Rockstar
Resident Rockstar

Sadly, this ability has been requested for years, but hasn't made it into Power BI yet.  I've seen some complciated work-arounds where people calcualte the resulting Line Chart Value Every X (5,10,15) units, to basically fake the ability with a Categorial Axis Type (this only works in very specific situations).

 

Please add your vote to these two requests to try to get movement on the idea:

https://ideas.powerbi.com/ideas/idea/?ideaid=6ba30ae6-6243-456a-9743-64441ddd7644

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17297545-add-the-axis-interval-in...

 




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors