Creating Scatter Chart in Power BI
Scatter chart in Power BI is used to display the relationship between two measures.
To create a scatter chart, you place measures on X-axis and Y-Axis. It uses bubbles/circles or any other available shapes to represent the values of the measures. A dimension can also be used to analyze measures over different categories.
In this blog, we will see how to create a Scatter chart to display relationship between Profit and Quantity over different subcategories.
New to Power BI? Get hands-on, step-by-step guidance in our Power BI for Beginners course. Start learning now.
How to create a Scatter Chart in Power BI
- Launch Power BI desktop and connect to an Orders table. This table contains Sales data and have fields like OrderID, OrderDate, Profit, Quantity ,Subcategory etc. Connecting to excel datasource
- Navigate to Report view and from the Visualizations select Scatter chart. This will create a place holder of the scatter chart. To create a scatter chart, you will place fields in the X-axis, Y-axis, Details, Legend etc.
3. From the Fields on the right, place Profit on the X-Axis, Quantity on the Y-Axis. This is give you just one bubble as it is displaying the relationship between the measures for the entire data set.
4. Place Sub- Category on the Details. You will get more bubbles now corresponding to the different Sub-category. But all the bubbles will be of the same color.
5. To get bubbles of different colors based on the Subcategories, place Sub-Category on the Legend. This will display bubbles in different colors.
6. Now we will set the size of the bubble based on the number of Orders. To achieve this, place OrderID on the Size.
7. All the field settings will look like
This will create a Scatter chart
The tooltip will display the values for Sub-Category, Profit, Quantity and the bubble size.
About the Author
Chandraish Sinha is the Founder and President of Ohio Computer Academy, a leading institution committed to delivering high-quality IT education. With a passion for teaching and a belief in his company’s mission—Inspire, Educate & Evolve—Chandraish brings over 25 years of experience in the Information Technology industry.
He is a prolific author, having published multiple books on Business Intelligence tools such as Tableau, Power BI, Qlik and other technologies. His most recent books include:
- IT Career Guide for Beginners: Steps to Launch and Develop a Successful Career in Information Technology
- Tableau for Job Seekers
- Excel Basics to Advanced – a comprehensive self-learning guide for mastering Microsoft Excel
- Dashboarding with Tableau – covering essential features and exercises for hands-on learning
Chandraish has successfully implemented IT solutions across diverse domains including pharmaceuticals, healthcare, telecom, finance, and retail. He actively blogs on trending IT topics and training strategies:
👉 Check out his latest posts:
Explore more of his work on his Amazon Author Profile.
