Forum Discussion

Croftie's avatar
Croftie
Advocate I
8 years ago

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. I suspect this is a Power BI bug given the number of posts about chart trun...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Croftie VidaLi,

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

Regards,
Lydia

  • VidaLi's avatar
    VidaLi
    Frequent Visitor
    8 years ago

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

    • v-haibl-msft's avatar
      v-haibl-msft
      Microsoft Employee
      8 years ago

      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

      • Croftie's avatar
        Croftie
        Advocate I
        8 years ago

        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