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 dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
76 | |
74 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
91 | |
51 | |
48 | |
47 |