Scatter Plot Chart in Microsoft Power BI

 

Click on the scatter chart from Visualization:

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

We can see sales and profit on chart.

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:

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

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:

Go to Format:

we will change color for minimum and maximum Profit Measure so that on seeing chart we can easily identify customer names for better Profit.

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

 

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

 

 

 

Comments

There are no entries yet.
Please enter the code
* Required fields

Subscribe to our mailing list

* indicates required

Looking for Corporate Training ? Reach out to us at Akriti.Lal@instrovate.com

Reach out to us if you are looking for Corporate Training to Build The Next Generation Analytical Workforce with an in-depth understanding of  Exploratory Data Analysis , Data Visualisation, Data Analytics , AI First , Machine Learning & Deep Learning Training & Consulting helping them to take Data Informed Decision at each stage of the business. 

We understand that At the present times , the Entire Industry is in a Tranformation stage with the Softwares  being rebuilt with Artificial Intelligence Capabilities .

We need SMART WORKFORCE for the SMART SOFTWARES to reap the maximum return . 

 

Whatsapp at +91-9953805788 or email at - akriti.lal@instrovate.com if you would like to know more . 

 

  • Corporate Tableau Training in Gurgaon
  • Corporate Data Analytics Training in Gurgaon
  • Corporate Microsoft Power BI Training in Gurgaon
  • Corporate Microstrategy Training in Gurgaon
  • Corporate Google Data Studio Training in Gurgaon
  • Corporate Python Training in Gurgaon
  • Corporate Advance Analytics in R Programming Training in Gurgaon
  • Corporate Machine Learning Training in Gurgaon
  • Corporate Deep Learning Training in Gurgaon
  • Corporate Data Visualization Training in Gurgaon

 

Address

Instrovate Technologies

Noida, Gurgaon

 

akriti.lal@instrovate.com 

Hit Your Refresh Button To Rise Higher
Print Print | Sitemap
All rights reserved @ Instrovate Technologies
GSTIN : 09AAECI6862K1Z1

Terms Of Services    Privacy Policy    Disclaimer     Refund Policy    


Call

E-mail