cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lalo_ATX Frequent Visitor
Frequent Visitor

simple scatter plot?

I'm at a loss. I can't figure out how to render a simple scatter plot.

 

I have a table (from sharepoint). I can export that table into excel, click on two columns, and insert -> scatter.

 

I can successfully "get data", the same sharepoint list, into Power BI Desktop. But it wants to aggregate the columns, and won't render a normal, typical, usual, boring old scatter plot.

 

How do I do that?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
jayeckles Member
Member

Re: simple scatter plot?

The fields you're using for the X Axis and Y Axis both need to be numeric types, and you have to have Details populated with something.

View solution in original post

5 REPLIES 5
alanhodgson Established Member
Established Member

Re: simple scatter plot?

Hey @Lalo_ATX,

 

This can easily be done with an R visual. Just put the 2 columns into the "Values" and type "plot(dataset)" in the console.

 

Capture8.PNG

 

Best,

 

Alan

Highlighted
jayeckles Member
Member

Re: simple scatter plot?

The fields you're using for the X Axis and Y Axis both need to be numeric types, and you have to have Details populated with something.

View solution in original post

Lalo_ATX Frequent Visitor
Frequent Visitor

Re: simple scatter plot?

Ah! Not intuitive, but it works. I suppose if I keep playing with it I might even figure out the best/appropriate/correct data to put in the Details field.

 

Thank you

chrissyk Frequent Visitor
Frequent Visitor

Re: simple scatter plot?

I tried this,  both my X and Y axis are numberic and I odn't get a scatterplot.

 

 What kind of data goes into Details field? Thank you! Any help appreciated.

jayeckles Member
Member

Re: simple scatter plot?

It can be literally almost anything in the details field.  The easiest way to select something is what would you want to show up in the tooltip if a user hovers over a particular point (the X, Y, and Detail values will be displayed in the tooltip).

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)