Custom Dot Bubble Chart

I want to create a chart like this.

I google it I found charticulator.com reference:https://www.reddit.com/r/PowerBI/comments/jbudid/trying_to_create_a_linear_bubble_chart/

but also didn't work for me. lts look like this.

can you guide what mistake I am doing or will not work with relationship data?