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,...
hassantm's avatar
hassantm
New Member
10 years ago

Hi MrJolly, 

 

Yes, that's correct.  Using the example "Financal Sample.xlsx" dataset from the PowerBI Desktop web site, if I wanted to plot the Manufacturing Price against the Month Number, there is no option to plot the raw values, even when I have set the columns to Do Not Summarize.  Adding Product to the Details box doesn't change the aggregation either.  

 

ScatterGraphSetup

 

This is true for both the 32 and 64 bit versions of Power BI Desktop.  I see the same behavour for line charts as well.  

 

The web version has the option to not aggregate the values.

 

Thanks

 

H

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

I am not sure why this is happening but as a workaround have you tried creating a measure to calculate the count and then using that on the scatter chart instead?

  • hassantm's avatar
    hassantm
    New Member
    10 years ago

    I don't want to calculate anything.  I'm just trying to plot X against Y in a scatter plot - no counting or aggregation of the values.  I'm trying to show the invidual values and then I'll plot a marker for the mean and some limits.  Hence the need to not summarize the data.

     

    H

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