how to set the granularity of Y Axis in line chart

[Anonymous]

One question here, I have a line chart and want to know how to set up the data range on Y Axis, now it only shows the gridline with value 0, 50, 100, I just want to add more granularity on Y Axis, like gridline 0, 20, 40, 60, 80, 100, can anybody advise? thanks in advance!

[Khashyar95]

You can import additional visuals like Inforiver Analytics+ and use them to build your charts. They are much more modifiable. However, you usually need a license to publish those plots in your report 

[Samthing]

This solution does not work, for example, when the data is between 0 and 100 like with punctuality data and the need is to display both values, as well as intermediate values as stated in the original question. Sometimes is rarely a good solution. This is easily handled e.g. in Excel but not in Power Bi ??

[LP280388 · Accepted solution]

@Anonymous 

I dont think the interval's are customizable and it also makes sense why they shouldnt be customizable. In case if you values go up and down, the visual should have the flexibility to show the high and low points right.

If you think you can ignore these high /low points then you can slightly adjust the Y axis max value as shown below which sometimes gives more granular intervals.  Caveat ! when you have any values more than this max value then it wont show up.  

[reiffaul]

I understand the potential issues with having customizable intervals. That's part of understanding your data and knowing what the potential range of values might be. What would be really useful is to be able to use an expression to set the interval. Then it's dyanmic based on your data, in the same way you can do in ssrs.

BTW, not trying to shoot the messenger here. I would just like this to be available.

[jcepb]

This is something that need to be solved in Power BI.