topic Re: simple scatter plot? in Desktop

simple scatter plot?

Anonymous — Fri, 02 Dec 2016 16:59:27 GMT

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?

Re: simple scatter plot?

alanhodgson — Fri, 02 Dec 2016 18:08:42 GMT

Hey @Anonymous,

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

Best,

Alan

Re: simple scatter plot?

jayeckles — Fri, 02 Dec 2016 18:11:29 GMT

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.

Re: simple scatter plot?

Anonymous — Fri, 02 Dec 2016 19:43:40 GMT

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

Re: simple scatter plot?

chrissyk — Wed, 14 Jun 2017 00:10:46 GMT

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.

Re: simple scatter plot?

jayeckles — Tue, 20 Jun 2017 20:55:29 GMT

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).