Can a Scatter Plot do this?

Hi all,

This is an extension on another graph I asked about before (https://community.powerbi.com/t5/Desktop/Graph-Visualization-Help-Showing-only-Decreases-and-Equal-to-0/m-p/1217034#M541804).

Let's take the same dataset from above (with some minor tweaking now):

As you can see above, the rating difference is essentially calculated using New Rating - Old Rating.

I want to create a Scatter Plot which shows the following:

• X-Axis using Old Rating as Categories
• Y-Axis showing Rating Difference
  • HOWEVER, the tricky part is - how do I show the same Customer ID on the Y-axis twice? I don't want the Rating Difference to be summarised, but every time I change it to a Text, the scatter plot doesn't work.
  • Ideally, as an example from the dataset I put above:
    
    • There should be two dots on Old Rating RT-3 for customer BOB. One which is a little higher due to having a Rating Difference of 3, and one which is slightly lower on RT-3 due Rating Difference of 2.
• For the Legend, I want to be switching between the Scenarios.
• As an added bonus, I want the size of the dots to also be dependent on the Value ($) column.

The tricky part right now I'm stuck on, is showing the same customer on the scatter plot separately without the rating differences being aggregated. Any help on what approach to take?

Thanks!