Displacing colliding point symbols in QGIS

Question

I have a layer that includes points for electric poles (Circles) and transformers (triangles). Transformers can be on poles or on their own. I would like to displace the transformers only if they are on top of a pole, keeping their exact location when they are on their own so they follow the electric wires. I have tried a conditional in the displacement expression box:

if( intersects(  $geometry ,  get_feature(  @layer_name , "Type" , 'Pole' )),1,0)

but it is not working.

What I don't want

What I want ONLY when there is a Pole (circle) present.

Answer 1

My guess is you are probably trying to something like this:

CASE 
WHEN count_distinct( "id" , group_by:= geom_to_wkt( $geometry ) ) >= 2
THEN '0.0,5.0'
ELSE '0.0,0.0'
END  

to be put into the data defined override expression in the Offset XY. (I used an "id" field but you can use any field in your attribute table.)

In the above example '0.0,5.0' is the XY offset, which moves the symbol 5.0 mm to the south. It does not have to be 5.0 and any number will do. If count_distinct() returns 1, it means there is no overlapping point and the point symbol does not move ('0.0,0.0').

Please note this expression does not discern if the overlapping points are Poles or Transformers. I just could not imagine two Poles sitting at the same location, and assumed that any overlap would mean Pole & Transformer.