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

[karo]

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

[v-juanli-msft]

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]

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]

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.