Forum Discussion

Anonymous's avatar
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...
Need Help
v-yulgu-msft's avatar
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's avatar
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's avatar
    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