It depends on the equation you are solving. For example, consider the following heat equation with a source term:
$$ \frac{dT}{dt} - \nabla^2 T = S$$
If $S \neq 0$, then you have a source term that changes the value of the temperature as time evolves. Consequently, even if your initial condition is $T(\textbf{x},t)=0$, your temperature will increase because of the source term. Then, having a Dirichlet or a Neumann boundary condition will lead to completely different result. If you have a Dirichlet (say $T=0$) then that boundary will remain at 0. If you have a Neumann, the gradient at the boundary will remain 0, thus the temperature will increase due to the source term. Consequently, you would get completely different temperature profile in the end.
There are many other examples you could use to explain the same phenomena. These are very different type of BCs, I would invite you to solve a 1D transient heat transfer problem and try it with both BCs and you will see that the resulting temperature profiles will be significantly different!