Help with scatter chart - new Power BI user

[Robbie]

Hello,

I hope I'm posting in the right location and this is an appropriate question. I've done a lot with SSRS and tabular reports but just getting into Power BI and visualizations. 

I'm working on a scatter chart right now. I'm wanting to see more of a variation between areas where there are high/low volume of visits and spend. I don't know if I need to change something with the visual, the data I'm using, or if I'm just not using an appropriate visualization for this data.

My data set right now is just customer id, number of visits the customer has, and total spent.

I build this by selecting scatter chart, Spent as X axis and set not summarize, Visits Y axis and set not summarize, Spent as size, and changing size of the shape to -15. 

The large bubble in lower right is a group of customers all with 1 visit and the same spent.

Thank you for any suggestions you might have. 

[v-xicai]

Hi  @Robbie ,

Does that make sense? If so, kindly mark the right answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

Hi @Robbie ,

You can turn on the High Density Sampling option to improves how scatter charts represent high-density data. For more detail, you can see :https://docs.microsoft.com/en-us/power-bi/desktop-high-density-scatter-charts .

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.