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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Croftie
Advocate I
Advocate I

Line chart truncation

Line charts appear truncated at the top when a minimum value of zero is set for the y-axis as per the example below.
Truncated line chart.png
I suspect this is a Power BI bug given the number of posts about chart truncation. The x-axis is categorical (as required to produce a line chart with markers), and making it continuous makes no difference to the truncation of y-axis labels.

Any advice would be greatly appreciated.

Steve

12 REPLIES 12
v-yuezhe-msft
Employee
Employee

@Croftie @VidaLi,

I will report this issue internally and post back once I get updates.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you Lydia. Looking forward to Microsoft's update about this.

@VidaLi @Croftie

 

I’ve got response from the Product Team.

 

This is by design currently. 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 of 19,418 as the top. Dropping the last label is by design to there is minimal whitespace and so we respect what the user has specified. This is the same as if the user had typed in 19,418 as the Max - they wouldn't want us to jump to 20k on the axis just to label the top.

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 20k 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.

 

Best Regards,
Herbert

Thanks for the response Herbert. 
I submit that in the context of having a dynamic visual whose maximum could vary considerably, hard-coding the maximum for anything other than a percentage or other logical maximum is generally not possible.

I don't know what algorithm Excel uses to determine a maximum when it is set to "Auto", but it would seem that Microsoft Excel has presented line charts nicely without truncation for a very long time, and with substantially more happy users.

Microsoft Power BI would do well to learn from that experience.

I look forward to a revision later in the year.

Steve

VidaLi
Frequent Visitor

hi @chass Charles,

 

I am hoping to get you attention. I definitely think this is a bug as Croftie raised in his original post. I am wondering if PBIX is going to fix this bug in the nearest release?

 

cheers,

Vida

VidaLi
Frequent Visitor

I am experiencing the same issue as mentioned by Steve. Hopefully someone knows how to fix this or is it a bug needs to be fixed by Microsoft?

 

cheers,

Vida

v-yuezhe-msft
Employee
Employee

@Croftie,

I can't reproduce your issue in the latest version of Power BI Desktop, you can review the example in my scenario. Do you use August version of Power BI Desktop(2.49.4831.521)? 

2.JPG1.JPG

Regards,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lydia, 

 

i am experience the same issue as Steve did. the reason why you couldn't replicate it, is because your max is big enough, so the line chart is not at the top of the edge, but it doesn't solve the issue though,

 

cheers,

Vida

Truncated line chart1.png

Yes - it is the August version. Can you try it with markers? Not that mine works without markers.

@Croftie,

Everything works well even turn on markers. You can review my PBIX file. Would you mind sharing me your PBIX file?

1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lydia, 

Thanks for the help.

Here is the pbix file.

Steve 

 

Just found the problem. When I set your Y-axis maximum as Auto (leaving minimum as zero), this replicates the problem.

The context in which we are using these line charts is such that setting a maximum value is not practical - when using a dropdown list the maximum varies from a few hundred to over 100,000.

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.