Step-by-Step Guide to Create a Scatter Plot in Power BI

1. Open Power BI Desktop:

Launch Power BI Desktop on your computer.

2. Load Your Data:

Click on Home > Get Data.

Choose your data source (e.g., Excel, SQL Server, etc.) and load your data into Power BI.

3. Select the Data for the Scatter Plot:

In the "Fields Pane", select the data fields you want to visualize. For example, you might choose Profit and sales.

4. Insert a Scatter Plot:

Go to the "Build" pane on the right side.

Click on the Scatter Plot icon.

5. Configure the Scatter Plot:

Drag the desired fields to the appropriate areas in the Build pane

6. Customize the Scatter Plot:

Use the "Format" pane to customize the appearance of your chart. You can change colors, add data labels, adjust axis titles, and more.

7. Save Your Report:

Once you're satisfied with your chart, save your report by clicking on File > Save As.

Example

Load the Sales Data:

Import your sales data into Power BI.

Create the Scatter Plot:

Select the "Scatter Plot" from the "Build" pane.

Add Fields:

Drag the "Sales" field to the "X - axis" 

Drag the "Profit " field to the "Y - axis" 

Drag the "Subcategory" field to the "Values" 

In the "Format" pane go to "Category label" and turn it on - you will be able to see the distribution of sales according to category on the scatter plot 

Customize:

Use the "Format" pane to adjust the chart's appearance.

By following these steps, you should be able to create a "Scatter plot" in Power BI that effectively visualizes your data

Try Following Formatting Options

1. Resize the category bubbles according to quantity

Drag the "Quantity" field to the "Size" - You will be able to see the bubble size changing according to quantity 

2. Change the colour of bubbles according to category

Drag the "Category" field to the "Legend" - You will be able to see the colour of bubbles changing according to Category

3. Animate the scatter plot

Drag the "Order Date" field to the "Play Axis" - You will be able to see animation in your scatter plot - to animate according to year - go to "Play Axis" under the "Build" pane - "Right click" on "Order date" under "Play Axis" - click on "Date hierarchy" in the dropdown