Welcome to the Affinity forums
You are getting the correct result for the blend settings that you have specified. The downward sloping graph is telling the app to make the text be fully opaque where the underlying composition is black and gradually become less opaque as the underlying composition becomes brighter.
If you can explain the effect that you wish to achieve, someone probably will be able to provide instructions. It would be particularly helpful if you can post a link to an example of the desired result.