Line Chart, Y-Axis, Start: Start 0 does not work, if all series only contain 0 values

[ChristianW]

Start 0 does not work for line charts if all the values in the chart are 0. See attached screenshot.

[metoda_technik]

No, this hasn't been fixed my Microsoft, but there is a workaround:

The -1 to 1 issue only occurs, if Maximum Range value for the y-axis is 'Auto'. So we can define a Measure to use as the Maximum value:

y-axis_max =
VAR maximum = MAXX(
    ALLSELECTED(myTable[Category]),
    SUM(myTable[Value])
)
RETURN
IF(maximum = BLANK(), 1, maximum)

[SLpang]

Hi @metoda_technik ,

Thank you so much for the workaround! It works like a charm. For my case, I just need to set the maximum to 1.0 (as my metrics DAX already captured and ensure the max won't be higher than 100%), and it works!

Thank you so much for your help. 🙂

Cheers,

SL