Forum Discussion

hassantm's avatar
hassantm
New Member
10 years ago

"Do Not Summarize" missing from scatter graph

I'm struggling to find a way to NOT summarise numerical data when plotting a scatter graph.  I can see the option in Power BI web, but not in the desktop version.  The data looks like    x = 1,2,3,...
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

You need another field in your table - something like a DATE or EVENT name etc...

 

 

Then drag either field or both fields as in the image below....

 

willsmithorg's avatar
willsmithorg
Icon for Advocate I rankAdvocate I
10 years ago

Have you put the same field you put in 'X axis' in your 'Details' section of the scatter graph?  I agree that it would be preferable to do scatter plots how Excel has done them for the last 10 years, but this workaround works for me.

 

Not only that, but I can now choose the aggregation level, e.g. I can round my X value down to an integer, and use that for the 'details'.  Now many X values are amalgamated to a single point, but if I set the X axis to 'average of ...' then it shows in the correct location, not at the rounded down location.  This helps the tradeoff between seeing all your data, and getting a dense cloud of points when you have thousands of data points.

 

 

 

 

 

 

  • kcantor's avatar
    kcantor
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Check your data type. In the data model you can specify do not aggregate.