Scatter chart same x-axis value data points got overlapped

[christinaxxx]

Hi, I've got this scatter plot. What I'm trying to achieve is to show the performance % by ID (ie., Franchisee) and apply colour conditional formatting using the Region info. No y-axis in my case (see my visual setting on the right).

However, there are many ID's that are having the same x-axis data points and I couldn't figure out how to show them all in the chart. Below is what I want to achieve (see the red dots):

I'm open to alternative visuals so if you have any better ideas of how best to show the data please let me know! Thanks!

[FarhanAhmed]

Good

[FarhanAhmed]

try Add performance% in y-axis as well

[christinaxxx · Accepted solution]

I managed to sort it out. Add the unique ID column (in whole number format) in y-axis

[christinaxxx]

Thank you, though it doesn't seem to be the way