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

simple scatter plot?

I'm at a loss.

 

I pulled a table from sharepoint and I simply want a scatter plot, with the X axis from one column, and the Y axis from another.

 

Power BI Desktop wants to sum the columns. Why won't it treat each data point independently?

 

So confused...

 

I was able to make a time-series line chart out of the same data (one of the input columns is the date), so apparently it can render data without summarizing it. It wasn't intuitive, but whatever.

1 REPLY 1
Phil_Seamark
Microsoft
Microsoft

For a scatter plot you need to decide the item you want to plot first. Eg. Product or region (any dimension really).

Once you have that, add that to Detail or Legend. The detail item can only have 2 numbers, one for each axis. Either of the numbers can be an aggregate such as SUM, AVG or MAX/MIN. But you need to boil down to a single number for each axis.

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors