Forum Discussion

karo's avatar
karo
Icon for Advocate V rankAdvocate V
7 years ago

Y axis : biggest data points not fully visible on Line chart

Hi,

I would like to start Y axis from 0 (a good data visualization practice) without fixed end value, however when I am trying to do this some of my biggest data points (markers)  are cut (not fully vissible on the chart).

Do you know any way to obtain dynamic Y axis started from 0 without such visual glitch?

Regards,

Karo

 

Need Help

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi karo 

    As tested, i find the same problem as yours on my side.

    Then i create a measure to calculate the max value for the Y-axis, add 1% of the max value to it, put the adjusted max value in the "End" of "Y-axis",

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • karo's avatar
      karo
      Icon for Advocate V rankAdvocate V
      7 years ago

      Hi v-juanli-msft ,

      I was also thinking about additional measure, however then I cannot use the tooltip, beacause this measure is only auxiliary and can be confiusing for the end users. 

      Adding the exact value as an end value for Y axis is also not prefered solution for me, because I would like to obtain dynamic Y axis, but starting from zero.

       

      Please consider my scenario:
      I have a line chart and slicer for Category.
      Category A max value = 10
      Category B max value =1000
      then putting the end point as 1000 or 1010 is not the best scenario, becasue then my line chart for Category B will be good, but for Category A will be hard to read.

       

      I really love dynamic axes in Power BI, but I would like to find a solution to combine this funcionality with starting Y axis from 0.

       

      Regards,

      Karo

       

      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi karo 

        As tested, it seems currently there is no option to change the start and end for Y axis according to your requirements.

         

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