Forum Discussion

Michael1's avatar
Michael1
Advocate II
9 years ago
Solved

Scatter Plot Aggregating X and Y

Hello Power BI Friends,   I am creating a Scatter Plot where the X-Axis and the Y-Axis are both two whole numbers in related tables.  The details are a key coming from one of the tables.   Howeve...
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    Hi Micheal

     

    You can use R script to get a scatter chart with non aggregated values. The script is simple.

     

    You should create your dataset by dragging the fields into the values area and write the below script.


    plot(dataset$SGPScore, dataset$SGPSTARRdg, xlab=”SGP Score”, ylab=”SGPSTARRdg”, xlim=c(0,300), ylim=c(0,300), main=”SGP Score Vs SGPSTARRdg”, pch=2, cex.main=1.5, frame.plot=FALSE, col=”green”)

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Hi Micheal

 

You can use R script to get a scatter chart with non aggregated values. The script is simple.

 

You should create your dataset by dragging the fields into the values area and write the below script.


plot(dataset$SGPScore, dataset$SGPSTARRdg, xlab=”SGP Score”, ylab=”SGPSTARRdg”, xlim=c(0,300), ylim=c(0,300), main=”SGP Score Vs SGPSTARRdg”, pch=2, cex.main=1.5, frame.plot=FALSE, col=”green”)

  • Michael1's avatar
    Michael1
    Advocate II
    9 years ago

    Hi Bhavesh,

     

    Thank you so much for your reply.  I attempted running this R script, but receive the error below. 

     

    I'd appreciate any assistance with this, as I have very little experience with R.

     

    Michael

     

    • Michael1's avatar
      Michael1
      Advocate II
      9 years ago

      Hi Bhavesh,

       

      I was able to write my first R Script.  Thank you for your help.

       

      I used: 

       

      plot(dataset$SGPScore, dataset$CurrentSGPSTARRdg, xlab="SGPScore", ylab="CurrentSGPSTARRdg", main="SGP Score Vs CurrentSGPSTARRdg", pch=2, cex.main=1.5, frame.plot=FALSE, col="green")

       

      Is there a way to have this visual interact with others, where I can click on a datapoint and then use thta to filter on a table?

       

      Thanks!

       

      Michael