Saturday, December 16, 2023

Lesson 16 - Scatter Chart in Power BI Desktop

A scatter chart is a very useful chart to visualize the relationship between two numerical variables. Power BI displays data point when two axes intersect. Scatter charts visualize how numerical data values of two axes are related. We can easily find the relationship between the data. We can add more information about data point using tool tip.


How to Proceed?


Step 1 
Launch power BI desktop app and open the new report page and import the data required. 


Step 2
In “visualizations” pane click on “Scatter Chart” which is highlighted in the given figure.


Step 3
Drag the data fields into “Field Section “that we want to compare and analyze.
 
X axis:  Horizontal category – Age 

Y axis: Vertical category – Height
Legend: Provides information about multiple data series 
In this simple scatter chart, we are showing gender wise medal distribution by their age Vs height.

Step 4
Filters in the chart are like special tools that allow us to focus on specific parts of the data, making it easier to understand. 

Step 5

Customizing the appearance of clustered column chart
You can customize the appearance of the visual.  You can change Title, Font size, Style, Colours and Data labels. 

Click anywhere on the visual and set the below properties in the Format section.


In this visual, I chose background colour as blue and gave 87% transparency which reduces the intensity of the colour.

Gave suitable title for the visual and customize the font size, colour and position of the title.

To add data labels to the chart, click on the “Category Label” section under “Visual”. Here you can choose which data to display in the labels and adjust their position, font, and color. 

Here in this scatter chart, we have more data points and it will look clumsier and so we kept category label to OFF.





To change the shape of the data point marker in scatter chart, click on the visual section in format visual.








To change the color of the legends used and to increase or decrease the size of the data points in Scatter chart click in the Visual section of format visual tab









To add more information to the scatter chart use tooltip option under Build visual tab





In this visual I have added the “No of Medals” to show added information when hovering on a mark in the chart along with their gender, age and height.

Finally, from the chart we can understand the how medal count varies across gender, age and height categories. Each data point corresponds to an individual.





Step 6 Save the visual

Finally, your basic scatter chart is ready. Click save button to save the visual.










When to use Scatter chart?

Scatter charts are useful when we want to visualize the relationship between two continuous variables or when we want to identify patterns, correlations, or trends in your data. 

Pros
  • Scatter chart is best in showing relationship between two variables
  • It gives quick overview of distribution of data points for end users
  • We can represent up to 10000 data points in scatter chart

Cons
  • We cannot use scatter chart to show relationship of more than two variables
  • Chart looks clumsy with dense data

Conclusion

Scatter charts are valuable for exploring relationships between two continuous variables, but they have limitations when it comes to handling more complex data. Choosing the right visualization for our specific analytical goals is more important


Tags Power BI
Useful links
MS Learn Modules
Test Your Knowledge Quiz

No comments:

Post a Comment