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!
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!
User | Count |
---|---|
104 | |
71 | |
67 | |
47 | |
45 |
User | Count |
---|---|
161 | |
85 | |
76 | |
68 | |
67 |