thanks for your answer.
If I set the axis fixed it is unfortunately not longer dynamically to the values.
I want the axis to adapt to the maximum of both years.
Do you also have a solution for this?
You can create the same bar chart for both years on the same sheet using a year parameter.
And then you can add the min and max reference lines (they are 2 calculated fields that do not depend on the selected year).
You will find herewith my proposal.
Comparison Years.twbx 24.8 KB