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,...
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

So just to be clear, in your Power BI model, do you have the following set to "Do Not Summarize" and it's still not working for your scatter?

 

 

 

 

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