Forum Discussion

Anonymous

Not applicable

9 years ago

Color code Products on a scatter plot Based on Profit and Quantity Sold

Hi All, I have a scatter plot of Products. The scatter plot has the axis Profitability Vs Popularity (No of Items Sold). Initial dataset is in the following format. Date, Product, Profit ,Ite...

Super User

9 years ago

There is a new visual which might be able to solve your issue

It is called Quadrant Chart

Anonymous

Not applicable

9 years ago

Thanks for the reply. Actually i cannot use the quadrant chart. Beacuse for my case i cannot divide the background into four equal sections. I have the scatter plot as shown in the following chart. I need to color the Products based on the Category/Quadrant which they fall into.

Regards,

Maddy

v-yulgu-msft
Microsoft Employee
9 years ago
Hi Anonymous,

As you know, it is not available to add a measure into legend section of a scatter chart since the measure needs to be sliced to get the corresponding data. Currently, Power BI scatter chart doesn't support quadrants. Someone has submitted this request here: Ability to show quadrants on scatter chart you can click to vote it up.

To work around this requirement, apart from using the custom visual Quadrant Chart, you can consider using R script if you are fimiliar with it. Here is a similar thread for your reference: R package to create scatter plots in quadrants?

As Quadrant Scatter Chart is supported in Excel, you can create Scatter Chart in Excel and then pin the chart to Power BI Service dashboard. Pin a tile to a Power BI dashboard from Excel

Best regards,
Yuliana Gu
- Anonymous
  Not applicable
  9 years ago
  Hi Yuliana,
  
  Thanks for the reply. Yes i am familiar with R and I will try the method which is given in the link.
  
  But I have a question. Will R visual interact with the filters?
  - v-yulgu-msft
    Microsoft Employee
    9 years ago
    Hi Anonymous,
    
    As I know, it seems that filter does not affect R visual.
    
    Regards,
    Yuliana Gu