Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
DaneM123
Frequent Visitor

Line graph - show gridline at top

I have a line graph in a report that shows like this:

 

Capture.PNG

What I would like would be for the graph to show the line for 3k (or whatever gridline would come next, depending on the graph). I know I could set the maximum value for the y axis, but then when I look at a different level of the data - where there might be 20,000 nominations - the line wouldn't show. Is there a way to always show the gridline above the maximum value?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@DaneM123

Do you mean that Y-Axis label is truncated in Line Chart when setting Y-Axis minimum to 0 and leaving Y-Axis maximum as Auto? If that is the case, this is by design currently.

The following response is from product team.

Once users set a min or max axis value, we use a combination of the specified values and/or the actual values where the user has not defined a value. So, once you set the Min, we change logic. Max is undefined so we use the real max value as the top. Dropping the last label is by design to there is minimal whitespace and so we respect what the user has specified.

All that said, we have discussed a plan to expose part of this behavior to the user as an option. The axis ticks can be rounded "nicely" to include the next label based on the tick interval - which would show 3k in this case. We will leave defaults as-is so existing visuals aren't affected, but we plan to introduce a new toggle to control whether the axis should extend to the next tick interval outside the domain or not.

No ETA right now, hopefully by end of this year.


Regards,
Lydia

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

@DaneM123

Do you mean that Y-Axis label is truncated in Line Chart when setting Y-Axis minimum to 0 and leaving Y-Axis maximum as Auto? If that is the case, this is by design currently.

The following response is from product team.

Once users set a min or max axis value, we use a combination of the specified values and/or the actual values where the user has not defined a value. So, once you set the Min, we change logic. Max is undefined so we use the real max value as the top. Dropping the last label is by design to there is minimal whitespace and so we respect what the user has specified.

All that said, we have discussed a plan to expose part of this behavior to the user as an option. The axis ticks can be rounded "nicely" to include the next label based on the tick interval - which would show 3k in this case. We will leave defaults as-is so existing visuals aren't affected, but we plan to introduce a new toggle to control whether the axis should extend to the next tick interval outside the domain or not.

No ETA right now, hopefully by end of this year.


Regards,
Lydia

Thanks - that is what I was hoping for. I find that the way it is at the moment makes the graphs quite hard to interpret, as it can be quite difficult to see how close the data points are to where the next line would be. While it does eliminate some white space it introduces an unnecessary element of estimation (IMO). Glad to be this is being looked at anyway.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors