Hi Samialfarra,
In SfDiagram, the minimum and maximum zooming limit will be from highest of 40% or screen size to 400%.
It can neither be zoomed out nor be zoomed in after that limit.
We are planning to implement dynamic Page support in our upcoming release, which will be helpful to achieve the mentioned scenario.
Thanks,
Arun