Forum Discussion
Avoid overlap in scatter chart
Hi, I needed a graph like the attached image. If I try with scatter chart then data is getting overlapped.
Kindly help me on this!
Thanks,
Gopi
Hi gopipowerbi,
I'm sorry for misunderstanding your "overlap in scatter chart" before.
By my test with your sample, It may be impossible for us to avoid the overlap because the values are same.
As a workaround, you could drag another column to the Size field and turn on the Gategory lables in Format Pane, then you could see the output below. I have test with Details and Legend.
The attachment is the test pbix file.
Best Regards,
Cherry
4 Replies
Hi, I have data like below. I needed a graph like the attached image. If I try with scatter chart then data is getting overlapped.
Kindly help me on this!
Thanks,
Gopi
ProjectName Importance Urgency TestQT 5 5 TestMicro 3 3 TestImp 3 3 Test Flow 3 3 Test Micro Proj 3 3 Test again 3 3 Test123 3 3 Test456 3 3 Daimler MCON 92 5 3 M22 - OnePager 3 5 Test flows 3 3 test again flow 3 3 testing 3 3 test QT 5 5 
Hi gopipowerbi,
Based the data you provided, I have made the visual below, but it seems that I cannot reproduce your scenario.
Besides, I cannot see the pictures you post secondly.
By my test, to avoid overlap in scatter chart, I suggest you could set start and end of the X axis and Y axis manually.
Then the shape should not overlap.
If you need additional help, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
Hi v-piga-msft
Thank you so much for your help on this!
Kindly find the sample pbix and help me in avoiding overlap even though I have changed x and y axis.
https://1drv.ms/u/s!AgBK-Ikdio7mhlVjw8SYOXHUi5ZE
Thanks,
Gopi
Hi gopipowerbi,
I'm sorry for misunderstanding your "overlap in scatter chart" before.
By my test with your sample, It may be impossible for us to avoid the overlap because the values are same.
As a workaround, you could drag another column to the Size field and turn on the Gategory lables in Format Pane, then you could see the output below. I have test with Details and Legend.
The attachment is the test pbix file.
Best Regards,
Cherry
