I found the solution by adding the HACS integration Zonneplan ONE and use the yield sensor for the solar panels in the energy dashboard. Now it shows what I actually use of my solar energy and what is returned to the grid! Gauges are working as well.
Next step is to reliably make sensors which are a combination of high and low tariff for production and consumption. I thought I had a solution but the sensors all of a sudden stopped calculating and I did not find a solution yet. This thread
