LOADING

Type to search

Scatter Plot Chart in Microsoft Power BI

To Know more about the Different Corporate Training & Consulting Visit our website www.Instrovate.com Or Email : info@instrovate.com or WhatsApp / Call at +91 74289 52788

Data Analytics PowerBI

Scatter Plot Chart in Microsoft Power BI

Share

Click on the scatter chart from Visualization:

Scatter Plot Chart in Microsoft Power BI 29

Drag and drop Sales on X Axis Profit on the Y axis:

Scatter Plot Chart in Microsoft Power BI 30

We can see sales and profit on chart.

Scatter Plot Chart in Microsoft Power BI 31

If we want to see which customer having more profitable business and which one is less profitable. Select Customer Name and drag it to the Details field:

Scatter Plot Chart in Microsoft Power BI 32

Here we can see which customer is having more +ve profit and which one have less

Scatter Plot Chart in Microsoft Power BI 33

We got this scatter chart to slow this question.

 

In last blog we have checked Profit Measure at level of Country or state or city.

Here we will check level of granularity on the bases on customer’s name. For Profit Measure we need to take Sum of Profit for this customer, and Sum of Sales for that customer. ( Profit measure = SUM(Orders[Profit]) / Sum(Orders[Sales]))

Now we will check at the granularity level of customer name for profit and sales. As we already have

column Profit Measure in our table.

Drag and drop Profit measure to the color saturation:

Scatter Plot Chart in Microsoft Power BI 34

Scatter Plot Chart in Microsoft Power BI 35

Go to Format:

Scatter Plot Chart in Microsoft Power BI 36we will change color for minimum and maximum Profit Measure so that on seeing chart we can easily identify customer names for better Profit.

Scatter Plot Chart in Microsoft Power BI 37

Let’s check +ve Profit Margin and -ve Profit Margin for any customer

Scatter Plot Chart in Microsoft Power BI 38

 

Scatter Plot Chart in Microsoft Power BI 39

We can see customer with positive and negative Profit Margin in percentage.

 

Tags:

You Might also Like

Leave a Comment

Your email address will not be published. Required fields are marked *