Labels of different magnitude on dual axis charts

[jnavarre]

Hello,

when i’m building a dual axis chart with 2 variables of very different magnitudes the labels on both axis are keeping the same magnitude, so one variable is not correctly labelled.

For example here is my sample data :

SELECT 
    year,
    var1,
    var2
FROM (
    values
    	(2019, 34668917, 62.66),
        (2020, 35057869, 59.17),
        (2021, 36843119, 67.73),
        (2022, 32979684, 52.82),
        (2023, 35885379, 54.55)
) AS t(year, var1, var2)

And the chart i’m building :

As you can see on the secondary right axis the var2 is also expressed in millions, and i can’t find a way to adjust that in the chart properties.

Any help would be appreciated

Thank You

[ErikG]

Hi @jnavarre
did you tried to format the var2 field itself?

BR

[jnavarre]

Thanks Setting it to auto did the trick