Question

You build a scatter chart plotting Profit Margin (x-axis) against Marketing Spend (y-axis), with one point per Product. Most products form a tight group, but three products sit far away with very high marketing spend and negative margins. Management wants a permanent visual grouping that separates these three underperforming products from the rest so they can be color-coded and referenced in future analysis, without editing the underlying data model in Power Query. What should you do?

Accepted Answer

Select the three outlier points on the scatter chart, right-click, choose Group data, then place the resulting group field on the Legend so the outliers are colored distinctly.

Answer

Add a visual-level filter that excludes the three products so they no longer appear on the scatter chart.

Answer

Use the Analyze feature's 'Find where this distribution is different' on the Profit Margin field to isolate the outliers.

Answer

Apply automatic clustering by using the '...' menu 'Automatically find clusters' option and accept the default number of clusters.