The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.).
Solved! Go to Solution.
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
Proud to give back to the community!
Thank You!
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...
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
Proud to give back to the community!
Thank You!
I went to vote for axis interval customization but the links above seem to be dead. This idea seems to be the one most supported by the community right now:
Epic idea: Advanced primary axis