To discuss Pisces compatibility we need to look at Pisces in combination with each of the other sun signs.
There are other planets which also affect someone's personality.
You'll find that some of these forums are generally positive in tone, and some are generally negative.
That doesn't guarantee that will be your experience, however you are very likely to recognize some common patterns which can be fascinating.
Aries is likely to be the leader sexually, and Gemini delights in thinking up variations to keep Aires's interest at a peak. Gemini and Cancer love compatibility Gemini's sparkle immediately intrigues Cancer, but Cancer won't find security with fickle, fly-by-night Gemini.
The Cancer's self-confidence will decrease during his dialogue with the changeable Gemini, who is fond of pleasures.